|
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@xxxxxx |
