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.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
