Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS

Tom Lane wrote:
> Andrew Dunstan <andrew@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