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

Re: how to add oids field

From: "gunartha(dot)nyoman" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how to add oids field
Date: 2007-03-20 02:45:07
Message-ID: 001501c76a99$c9585b60$fd0010b2@idas (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Okey, Mr Radlowski and Mr. Drake
 thank for your comment


----- 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.

---------------------------(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

In response to

pgsql-admin by date

Next:From: gunartha.nyomanDate: 2007-03-20 02:49:22
Subject: how to create field auto increas value
Previous:From: Joshua D. DrakeDate: 2007-03-20 02:29:41
Subject: Re: how to create field auto increas value

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