Re: Copying few tables from one database to another

On Mar 6, 2011, at 7:13 PM, Alexander Farber wrote:

> what is please the command to copy tables from 1 database
> from another and is it possible at all without using pg_dump?



You can create Structure of table in New database and then you can use COPY Command to copy data as given below:
psql -c 'COPY tablename to STDOUT;' dbname|psql -c 'COPY tablename from STDIN;' dbname


Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com