Re: [GENERAL] pg_dump -t <> pg_restore -t
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] pg_dump -t <> pg_restore -t
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] pg_dump -t <> pg_restore -t
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