Tom Lane wrote:
Andrew Dunstan <and...@dunslane.net> writes:
Heikki Linnakangas wrote:
Andrew Dunstan wrote:
How about a pg_dump flag that simply suppresses OIDs from the data
and schema?
pg_dump -s postgres | sed -e 's/SET default_with_oids = true;/-- &/'
No good for non-text dumps.
Also it would fail badly if the dump had in fact been made with -o.
Don't do that then. We're not talking about filtering any old dump you
have lying around. We're talking about adding a new flag to pg_dump. If
you can run pg_dump with a new flag, surely you can run it without -o in
text mode and use sed just as well.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
