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

From Paresh Bafna
Subject Re: Getting table name/tuple from OID
Date
Msg-id 436F7E30.7090706@it.iitb.ac.in
Whole thread Raw
In response to Re: Getting table name/tuple from OID  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Getting table name/tuple from OID  (huaxin zhang <uwcssa@gmail.com>)
List pgsql-hackers
Actually I want to do this from inside the postgres code i.e. I want to
get table name and tuple values from OID of corresponding table OID and
tuple OID.
Is there any built in function in postgres code to do this?

Paresh

Christopher Kings-Lynne wrote:

> 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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another pgindent gripe
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Old interfaces directory in CVS tree?