Re: how to add oids field

Okey, Mr Radlowski and Mr. Drake
thank for your comment

Regards,
Nyoman/Bali

----- Original Message -----
From: "Adam Radlowski" <adamr(at)informatyka(dot)gdansk(dot)pl>
To: "gunartha.nyoman" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Friday, March 16, 2007 8:50 PM
Subject: Re: [ADMIN] how to add oids field

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match