postgres: OID

[nightowl]

the OID is unique for every record, no matter what table it's in, in postgresql. Is there a way to select a record, using its OID, if you don't know what table it's in ?

select * from myTableName where oid='$oid' works fine - but what if you don't know myTableName and just want that records with that oid ?

[Sxooter]

Keep in mind, OIDs, while optional for table rows, are used to keep track of indexes, views, tables, i.e. just about every object in the database besides a table's rows needs and OID, so it's possible to have an OID that doesn't point to a table row. Just FYI.

I know no way to find an arbitrary row in an arbitrary table with just the OID.

Why do you need to do this? Is there some basic design flaw in your code you're trying to get around?