Copying few tables from one database to another
Hello,
what is please the command to copy tables from 1 database
from another and is it possible at all without using pg_dump?
I'm trying to migrate 4700 users from phpBB 3 to Drupal 7
and have few custom tables in the "phpbb" database
which need to be copied over.
Using CentOS 5.5/64 bit + PostgreSQL 8.4.7
Thank you for the hints into the right direction
Alex
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