Removing OIDs

Поиск
Список
Период
Сортировка
Искать

Removing OIDs

От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
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

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

Re: Removing OIDs

От:
Marek Lewczuk <newsy@lewczuk.com>
Дата:
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.

 
FAQ