Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Get relation name form relids in postgresql - Mailing list pgsql-sql

From Rene Romero Benavides
Subject Re: [SQL] Get relation name form relids in postgresql
Date
Msg-id CANaGW08RWos2hiwQAwCThtWV4yUe2Bt+VQ2+s-3LQyM9=o-yhg@mail.gmail.com
Whole thread Raw
In response to [SQL] Get relation name form relids in postgresql  (Gourav Kumar <gourav1905@gmail.com>)
Responses Re: [SQL] Get relation name form relids in postgresql  (Gourav Kumar <gourav1905@gmail.com>)
List pgsql-sql
Tree view
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@gmail.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/

pgsql-sql by date:

Previous
From: Gourav Kumar
Date:
Subject: [SQL] Get relation name form relids in postgresql
Next
From: Gourav Kumar
Date:
Subject: Re: [SQL] Get relation name form relids in postgresql