alexandre - aldeia digital wrote:
Hi, If I do: pg_dump -Fc -t TABLE database > table-custom.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 is returned but it's include all elements. But if I do: pg_dump -Fc database > backup-custom.file pg_restore -Fc -t TABLE backup-custom.file > table-plain.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 ?
The -l / -L options let you create/read back a control file listing all the database objects. You can comment out/edit this to control pretty much everything.
-- Richard Huxton Archonet Ltd
