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