Re: Removing OIDs - Mailing list pgsql-admin

From Marek Lewczuk
Subject Re: Removing OIDs
Date
Msg-id 401F9CE1.5020604@lewczuk.com
Whole thread Raw
In response to Removing OIDs  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
List pgsql-admin
Sam Barnett-Cormack wrote:

> Is there any way to remove OIDs from an existing table, or even a whole
> database? I never use the damn things and my database is big, so I'd
> like to do anything I can to shrink it.
>
> Also, are there any performance implications to this?
>
> I'm currently using 7.3.4, but will shortly be moving to 7.4
>

ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS

ML.



pgsql-admin by date:

Previous
From: Sam Barnett-Cormack
Date:
Subject: Removing OIDs
Next
From: Mark Lubratt
Date:
Subject: pg_dump privileges