Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a database (it's Postgres, if that matters) and I would like to take two of its tables, export them, and then import them into another database. How do I do that?

Edited to add Google bait: dump load

share|improve this question
add comment

2 Answers

up vote 9 down vote accepted

Use pg_dump with the -t option (which you can specify multiple times):

pg_dump -t foo -t foo1 dbname1 > dump.sql

Restore in the new database:

psql -U username dbname2 < dump.sql
share|improve this answer
add comment

If the other database is not managed by Postgresql use pg_dump, as in Gary's hint, but with the -D flag, it makes the import process much more robust. You will have to create the schemas on the target system

(sorry, can't add a comment to Gary's answer as I don't have enough points)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.