Re: [HACKERS] Getting table name/tuple from OID

[Christopher Kings-Lynne]

Try

SELECT 12341234::regclass;

Where 12341234 is the OID of a table.

Otherwise try:

SELECT tableoid, * FROM table;

To get the tableoid on each row.

Chris

Paresh Bafna wrote:

Is there any way to retrieve table name and/or tuple values from OID of
table/tuple?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings