Re: OIDs - Mailing list pgsql-novice

From Frank Bax
Subject Re: OIDs
Date
Msg-id 5.2.1.1.0.20050502171648.03fb8d60@pop6.sympatico.ca
Whole thread Raw
In response to OIDs  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Havasvölgyi Ottó
Date:
Subject: Re: how to make collation work
Next
From: Terry Lee Tucker
Date:
Subject: Re: OIDs