On Fri, May 22, 2020 at 9:15 AM stan <stanb@xxxxxxxxx> 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:
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].
David J.
