Re: Get relation name form relids in postgresql

Sure, you can cast the relid to regclass, or join the mentioned table.

2017-10-05 21:48 GMT-05:00 Gourav Kumar <gourav1905(at)gmail(dot)com>:

> Hi,
>
> Thanks for the reply.
>
> I want to be able to do that from inside the postgres code, while I am in
> middle of executing a Query.
> On 06-Oct-2017 7:12 AM, "Rene Romero Benavides" <rene(dot)romero(dot)b(at)gmail(dot)com>
> wrote:
>
>> Hi. Try pg_catalog.pg_stat_user_tables, there you have the relid (oid)
>> identifier
>>
>> 2017-10-05 13:17 GMT-05:00 Gourav Kumar <gourav1905(at)gmail(dot)com>:
>>
>>> Hi all,
>>>
>>> I am looking for a way to get the relation name from the relid or
>>> RelOptInfo data structure. Can anyone help me with this ? How can I use
>>> these to get to relation name ?
>>>
>>> --
>>> Thanks,
>>> Gourav Kumar
>>>
>>>
>>
>>
>> --
>> El genio es 1% inspiración y 99% transpiración.
>> Thomas Alva Edison
>> http://pglearn.blogspot.mx/
>>
>>

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/