Richard Huxton wrote: > 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. Ok. But I have a lot of tables, and this tables have a lot of indexes. How can I get all objects related to a table ? Thanks, Alexandre
