Re: how to add oids field - Mailing list pgsql-admin

From Adam Radlowski
Subject Re: how to add oids field
Date
Msg-id 45FAA0B7.9000308@informatyka.gdansk.pl
Whole thread Raw
In response to how to add oids field  ("gunartha.nyoman" <gunartha.nyoman@ptjas.co.id>)
Responses Re: how to add oids field  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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


pgsql-admin by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: pl/pgsql function spikes CPU 100%
Next
From: "Joshua D. Drake"
Date:
Subject: Re: how to add oids field