[GENERAL] differences between pg_dump and pg_restore with -t

[alexandre - aldeia digital]

Hi,

If I do:
pg_dump -Fc -t table database > table.sql

The pg_dump returns the DDL of the table, the data and the DDL for 
indexes and PK. If I use -s, only the structure, but all is returned.

But if I do:

pg_dump -Fc database > backup.file
pg_restore -Fc -t table backup.file > table.sql

Only the DDL of table and data is returned, but not indexes, etc.

Question:

How can I restore a table with all other dependences from a custom file 
database ?

PG: 8.1.2 and 8.0.6

Thanks,

Alexandre



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match