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

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...)