Re: pg_dump -- data and schema only?

> Am Donnerstag, den 04.08.2005, 10:26 -0400 schrieb Mark Woodward:
>> I haven't seen this option, and does anyone thing it is a good idea?
>>
>> A option to pg_dump and maybe pg_dump all, that dumps only the table
>> declarations and the data. No owners, tablespace, nothing.
>>
>> This, I think, would allow more generic PostgreSQL data transfers.
>
> pg_dump -s maybe?
>
> See man pg_dump:
>
> -s
>
> --schema-only
> Dump only the object definitions (schema), not data.
>
> Usually one dumps the database with -Fc and then construct
> SQL for data and DDL via pg_restore from this binary dump.
> You can then use pg_restore -l, edit (for example via sed)
> and use it with -L to only generate SQL for these objects.
>

Actually, there isn't a setting to just dump the able definitions and the
data. When you dump the schema, it includes all the tablespaces,
namespaces, owners, etc.

Just the table nd object declarations and data would be useful.