RE: [GENERAL] [Q] Examples of using OIDs

[Evan Howarth]

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