Re: Getting table name/tuple from OID - Mailing list pgsql-hackers

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