Re: postgres - oid question

On Thu, 2007-05-24 at 10:58 -0700, bruce wrote:
> Hi...
>
> In looking over a few sites via google, I'm trying to figure out what has to
> be added to the sql I have for creating TBLs that use OIDs. I'd rather have
> the cmds added to the sql file, than the postgres conf file...
>
> I can't find out what I have to add!
>
> I understand that OIDs are depricated, but the app I'm dealing with has
> them. I'm using v8.1 of postgres on Fedora 5.
>
> Any pointers are appreciated.

TO create one table with oids, use
CREATE TABLE table_name (...) WITH OIDS;

To have all tables created with oids, set the config parameter
default_with_oids to true. (It defaults to false from 8.1 onwards.)

Oliver Elphick