Re: Killing OIDs

"Joshua D. Drake" <jd@commandprompt.com> writes:
> On Wed, 2009-02-11 at 09:41 -0800, Steve Crawford wrote:
>> My plan is to do the OID removal on 7.4. I can get a script with:
>> SELECT
>> 'ALTER TABLE ' || relname || ' SET WITHOUT OIDS;'

> That won't drop the OID columns.

Sure it will.  I'd be a little worried about whether he shouldn't
be using quote_identifier and/or schema-qualifying the names, but
SET WITHOUT OIDS is the right command to be issuing.

            regards, tom lane