This will return all columns including the OID:
select oid,* from my_table
To index the OID column:
create index my_table_oid on my_table( oid )
Other tables can reference the OID column:
create table another_table (
...
my_table_ref oid not null,
..
)
Because PostreSQL ignores the "foreign key" keywords,
you have to maintain referential integrity yourself.
Evan Howarth