Thread: Removing OIDs
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
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.