Am Donnerstag, den 04.08.2005, 11:52 -0400 schrieb Mark Woodward: > > 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.
Reread my comment on the -l / -L option to pg_restore. You can do all that with it :-) -- Tino Wildenhain <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match