On Fri, May 22, 2020 at 9:15 AM stan <st...@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.