Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the OID of a view - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to get the OID of a view
Date
Msg-id CAKFQuwYX28ZqrOkpt5=F-S_xnX=7=eOG+isW-iUG8Q_o-_CAPA@mail.gmail.com
Whole thread Raw
In response to How to get the OID of a view  (stan <stanb@panix.com>)
List pgsql-general
Tree view
On Fri, May 22, 2020 at 9:15 AM stan <stanb@panix.com> wrote:
I am trying to write a query to return the names, and data types of all the
columns in a view. It has been pointed out to me that the best approach
would be using pg_catalog. OK, so I found pg_view, which I can get the names
of a the views from and pg_attribute which can give me the column names,
but it looks like i need to join this on OID, and pg_table does not have
that data.


The table you want is pg_class:

https://www.postgresql.org/docs/12/catalog-pg-class.html

If the system views listed in [1] don't provide you what you need you need to fall-back to the system tables listed in [2].

[1] https://www.postgresql.org/docs/12/views-overview.html 
[2] https://www.postgresql.org/docs/12/catalogs-overview.html

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get the OID of a view
Next
From: Scott Ribe
Date:
Subject: query, probably needs window functions