From: | Gourav Kumar <gourav1905(at)gmail(dot)com> |
---|---|
To: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Get relation name form relids in postgresql |
Date: | 2017-10-06 02:55:50 |
Message-ID: | CAPzqDmjBDFhUfQAfYwFKkwwjjvWOMPRRTjtOO44645ZWMNsRHg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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/
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Romero Benavides | 2017-10-06 03:00:56 | Re: Get relation name form relids in postgresql |
Previous Message | Rene Romero Benavides | 2017-10-06 02:54:02 | Re: Get relation name form relids in postgresql |