Re: [GENERAL] pg_dump -t <> pg_restore -t

2006-04-27 Thread alexandre - aldeia digital
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 elem

Re: [GENERAL] pg_dump -t <> pg_restore -t

2006-04-26 Thread Richard Huxton
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 > ba

[GENERAL] pg_dump -t <> pg_restore -t

2006-04-26 Thread alexandre - aldeia digital
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 T