Thread: [SQL] Get relation name form relids in postgresql

[SQL] Get relation name form relids in postgresql

From
Gourav Kumar
Date:
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

Re: [SQL] Get relation name form relids in postgresql

From
Rene Romero Benavides
Date:
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/

Re: [SQL] Get relation name form relids in postgresql

From
Gourav Kumar
Date:

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.romero.b@gmail.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@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/

Re: [SQL] Get relation name form relids in postgresql

From
Rene Romero Benavides
Date:
Sure, you can cast the relid to regclass, or join the mentioned table.


2017-10-05 21:48 GMT-05:00 Gourav Kumar <gourav1905@gmail.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.romero.b@gmail.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@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/




--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

Re: [SQL] Get relation name form relids in postgresql

From
Gourav Kumar
Date:

I did not get this part. Can you elaborate please.

On 06-Oct-2017 8:24 AM, "Rene Romero Benavides" <rene.romero.b@gmail.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@gmail.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.romero.b@gmail.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@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/




--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

Re: [SQL] Get relation name form relids in postgresql

From
Rene Romero Benavides
Date:
Sure, if you cast a field that contains a relid to the reglass type, you get the name of the relation.

Example:
select relid, relid::regclass from pg_stat_user_tables where relname = 'theNameOfYourTable';


2017-10-05 21:55 GMT-05:00 Gourav Kumar <gourav1905@gmail.com>:

I did not get this part. Can you elaborate please.

On 06-Oct-2017 8:24 AM, "Rene Romero Benavides" <rene.romero.b@gmail.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@gmail.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.romero.b@gmail.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@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/




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

Re: [SQL] Get relation name form relids in postgresql

From
Gourav Kumar
Date:

But I can't fire a query when I am inside postgres code, while executing another query.

On 06-Oct-2017 8:31 AM, "Rene Romero Benavides" <rene.romero.b@gmail.com> wrote:
Sure, if you cast a field that contains a relid to the reglass type, you get the name of the relation.

Example:
select relid, relid::regclass from pg_stat_user_tables where relname = 'theNameOfYourTable';


2017-10-05 21:55 GMT-05:00 Gourav Kumar <gourav1905@gmail.com>:

I did not get this part. Can you elaborate please.

On 06-Oct-2017 8:24 AM, "Rene Romero Benavides" <rene.romero.b@gmail.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@gmail.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.romero.b@gmail.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@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/




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

Re: [SQL] Get relation name form relids in postgresql

From
Rene Romero Benavides
Date:
Mmm, what do you mean by postgres code ? Are we talking here about the postgres source code or SQL ? If it's the source code, that's beyond my knowledge, sorry. The pgsql-hackers list may be a better fit for what you're looking for, or perhaps pgsql-general

Best.
.

2017-10-05 22:04 GMT-05:00 Gourav Kumar <gourav1905@gmail.com>:

But I can't fire a query when I am inside postgres code, while executing another query.

On 06-Oct-2017 8:31 AM, "Rene Romero Benavides" <rene.romero.b@gmail.com> wrote:
Sure, if you cast a field that contains a relid to the reglass type, you get the name of the relation.

Example:
select relid, relid::regclass from pg_stat_user_tables where relname = 'theNameOfYourTable';


2017-10-05 21:55 GMT-05:00 Gourav Kumar <gourav1905@gmail.com>:

I did not get this part. Can you elaborate please.

On 06-Oct-2017 8:24 AM, "Rene Romero Benavides" <rene.romero.b@gmail.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@gmail.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.romero.b@gmail.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@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/




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




--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/