Re: postgres - oid question

Hi Oliver.

Thanks for the reply.

I was hoping that there was/is a single cmd that I could use at the
beginning of the sql file, that would allow all the tables that are created
to be created using the OID. Kind of a

use OID
create tbl Foo1
create tbl Foo2
create tbl Foo3
create tbl Foo4
create tbl Foo5
stop OID
create tbl Foo6
create tbl Foo7

so that everything created between use/stop would be created using OID...

thanks

-bruce

-----Original Message-----
From: Oliver Elphick [mailto:olly(at)lfix(dot)co(dot)uk]
Sent: Thursday, May 24, 2007 11:19 AM
To: bedouglas(at)earthlink(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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