postgres copy table from 1 db to another

pb_tbl.md

Copy from source table: dvn_thedata -> authenticateduser

• Go to the psql shell: psql dvn_thedata
• Copy to a text file:

\copy (select id, affiliation, email, firstname, lastname, modificationtime, position, superuser, useridentifier from authenticateduser order by id) to '/tmp/auth_user.csv' CSV HEADER

Load to the target table: dvndb -> authenticateduser

• Modify the csv if needed--e.g. if don't want to overwrite existing rows
• Go to the psql shell: psql dvndb
• Load the text file

copy authenticateduser(id, affiliation, email, firstname, lastname, modificationtime, position, superuser, useridentifier) 
FROM '/tmp/auth_user.csv' DELIMITER ',' CSV HEADER;