Re: Get relation name form relids in postgresql

From: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
To: Gourav Kumar <gourav1905(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Get relation name form relids in postgresql
Date: 2017-10-06 01:42:24
Message-ID: CANaGW08RWos2hiwQAwCThtWV4yUe2Bt+VQ2+s-3LQyM9=o-yhg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gourav Kumar 2017-10-06 02:48:00 Re: Get relation name form relids in postgresql
Previous Message Gourav Kumar 2017-10-05 18:17:36 Get relation name form relids in postgresql