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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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