| 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:48:00 |
| Message-ID: | CAPzqDmg=yyO3oki2Qm4HBRYjHy=rR8EXChkLX-LSYf-jKN+U1g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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/
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rene Romero Benavides | 2017-10-06 02:54:02 | Re: Get relation name form relids in postgresql |
| Previous Message | Rene Romero Benavides | 2017-10-06 01:42:24 | Re: Get relation name form relids in postgresql |