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 ? PG 8.1.3 Thanks, Alexandre ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
