Re: Removing OIDs

From: Marek Lewczuk <newsy(at)lewczuk(dot)com>
To: Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk>
Cc: PostgreSQL Administrators Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Removing OIDs
Date: 2004-02-03 13:06:41
Message-ID: 401F9CE1.5020604@lewczuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sam Barnett-Cormack wrote:

> Is there any way to remove OIDs from an existing table, or even a whole
> database? I never use the damn things and my database is big, so I'd
> like to do anything I can to shrink it.
>
> Also, are there any performance implications to this?
>
> I'm currently using 7.3.4, but will shortly be moving to 7.4
>

ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS

ML.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Lubratt 2004-02-03 13:54:41 pg_dump privileges
Previous Message Sam Barnett-Cormack 2004-02-03 11:55:41 Removing OIDs