moving all of my own tables to a new d.b.

create

Using webfaction Control Panel:

• Create location_data
  • -> PostGIS extensions

ref: https://stackoverflow.com/questions/3195125/copy-a-table-from-one-database-to-another-in-postgres

says:

    pg_dump -t table_to_copy source_db | psql target_db

So, here goes:

    12:26:01 angela $ pg_dump -U adminw -t farmers sqlcarrots | psql -U adminw location_data
    SET
    SET
    SET
    SET
     set_config
    ------------

    (1 row)

    SET
    SET
    SET
    SET
    SET
    CREATE TABLE
    ALTER TABLE
    COPY 8731
    REVOKE
    REVOKE
    GRANT
    GRANT

Yep, seems to have worked, here goes the rest...

    pg_dump -U adminw -t cheesemag sqlcarrots | psql -U adminw location_data
    pg_dump -U adminw -t farmers   sqlcarrots | psql -U adminw location_data
    pg_dump -U adminw -t roadside  sqlcarrots | psql -U adminw location_data