Forum OpenACS Q&A: copy table from one db to another

Collapse
1: copy table from one db to another
Posted by David Kuczek on 11/15/01 10:19 AM
Has anyone ever copied one table and its content (without constraints)
from one db to another on the same machine?

What command do I have to use for that?

Collapse
2: Response to copy table from one db to another (response to 1)
Posted by Steve Woodcock on 11/15/01 10:30 AM

You can do it with pg_dump:

  pg_dump -t the_table db1 | psql db2
Collapse
3: Response to copy table from one db to another (response to 1)
Posted by David Kuczek on 11/15/01 11:57 AM
Thanks a lot... It worked
Collapse
4: Response to copy table from one db to another (response to 1)
Posted by Jeff Barrett on 11/15/01 03:18 PM
Can this be done for a remote machine? If I wanted to dump a table on dbmachine1 and have it loaded into dbmachine2 is their a way I can do that?
Collapse
5: Response to copy table from one db to another (response to 1)
Posted by Steve Woodcock on 11/15/01 03:37 PM
Have a look at man psql, the -h and -U options, for something like this: 
[dbmachine1]$ pg_dump -t the_table db1 | psql -h dbmachine2 db2
(Note I've never actually done this myself...)