Re: [GENERAL] OID question

[Ed Loehr]

Chris Sutton wrote:
> 
> I would like to use the oid as a unique key for a table but in creating
> a test table and playing around with inserts, things don't seem to be
> working as I thought they would.
> 
> Where am I going wrong?


There is a hidden column named 'oid'.  Try "select oid, desc from
test".

Regards,
Ed Loehr

P.S.:  An alternative approach worthy of consideration is to use a
SEQUENCE object and possibly the SERIAL type.