Re: How to get the OID of a view
| От | David G. Johnston |
|---|---|
| Тема | Re: How to get the OID of a view |
| Дата | |
| Msg-id | CAKFQuwYX28ZqrOkpt5=F-S_xnX=7=eOG+isW-iUG8Q_o-_CAPA@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to get the OID of a view (stan <stanb@panix.com>) |
| Список | pgsql-general |
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:
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.
В списке pgsql-general по дате отправления: