Re: Get relation name form relids in postgresql

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/
>
>

In response to

Responses

Browse pgsql-sql by date

  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