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.
create table test (
key oid,
desc varchar(30));
Then I do an insert
insert into test (desc) values ('info');
which returns 100448 1 (i'm assuming 100448 is the oid for that row).
But when I look at the table 100448 is not showing up on the key column
key|desc
---+----
|info
What I expected was
key |desc
------+----
100448|info
Where am I going wrong?
Chris