RE: [GENERAL] [Q] Examples of using OIDs - Mailing list pgsql-general

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