Postgres Pro
Downloads
Home   >   mailing lists

Thread: OIDs

OIDs

From
"Keith Worthington"
Date:
Hi All,

Is it possible to change a table from 'WITH OIDS' to 'WITHOUT OIDS' and vice
versa or must I DROP TABLE and CREATE TABLE using the desired attributes?

Kind Regards,
Keith

Re: OIDs

From
Frank Bax
Date:
At 05:09 PM 5/2/05, Keith Worthington wrote:
>Is it possible to change a table from 'WITH OIDS' to 'WITHOUT OIDS' and vice
>versa or must I DROP TABLE and CREATE TABLE using the desired attributes?

http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html

The "SET WITHOUT OIDS" paragraph answers both questions.

Re: OIDs

From
Terry Lee Tucker
Date:
From the psql interface:

rnd=# \h alter table
ALTER TABLE [ ONLY ] name [ * ]
    SET WITHOUT OIDS

On Monday 02 May 2005 05:09 pm, Keith Worthington saith:
> Hi All,
>
> Is it possible to change a table from 'WITH OIDS' to 'WITHOUT OIDS' and
> vice versa or must I DROP TABLE and CREATE TABLE using the desired
> attributes?
>
> Kind Regards,
> Keith
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org