Re: Get relation name form relids in postgresql

Sure, if you cast a field that contains a relid to the reglass type, you
get the name of the relation.

Example:
select relid, relid::regclass from pg_stat_user_tables where relname =
'theNameOfYourTable';

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

> I did not get this part. Can you elaborate please.
> On 06-Oct-2017 8:24 AM, "Rene Romero Benavides" <rene(dot)romero(dot)b(at)gmail(dot)com>
> wrote:
>
>> 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/
>>
>>

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