Skip site navigation (1) Skip section navigation (2)

Re: how to add oids field

From: Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: "gunartha(dot)nyoman" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to add oids field
Date: 2007-03-16 13:50:47
Message-ID: 45FAA0B7.9000308@informatyka.gdansk.pl (view raw or flat)
Thread:
Lists: pgsql-admin
gunartha.nyoman napisaƂ(a):
> hi, 
>
> I am new comer in this millis...
> i have a poblem, how to add a field/column in existing table without oids.
> if i create new table i can add field oids
>
> Thank alot before
>
> regrads
> Nyoman/bali
>   
So - create a new table with this same structure, but with oids, copy 
all records into new table. Retrive all the information about the old 
table (keys, indexes, triggers, etc.). Delete old table, rename new 
table to old name, create all needed indexes, keys, triggers,etc.
bregards
Adam


In response to

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2007-03-16 14:20:31
Subject: Re: how to add oids field
Previous:From: Shoaib MirDate: 2007-03-16 09:36:07
Subject: Re: pl/pgsql function spikes CPU 100%

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group