Hi all,
Recently I want to import a new table into a existing database, I run with follow steps:
1. Export my whole database schema from test machine database: pg_dump -s -F t –f dumpfile database
2. Import only one table into existing database: pg_restore -F t –d database -t tablename dumpfile
The problem is the table ‘tablename’ schema import correctly, but didn’t import the indexes, constrains and column comments of this table. Can somebody do me a favor about understanding why this doesn’t work?
Thanks,
Best Regards,
Vincent Ma(Ma Dong)
Hewlett-Packard Co.
IDD: +86 010 6564 5733
Email: dong.ma@hp.com
