How to get the OID of a view
От | stan |
---|---|
Тема | How to get the OID of a view |
Дата | |
Msg-id | 20200522161534.GA29059@panix.com обсуждение исходный текст |
Ответы |
Re: How to get the OID of a view
Re: How to get the OID of a view Re: How to get the OID of a view Re: How to get the OID of a view |
Список | pgsql-general |
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. -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin
В списке pgsql-general по дате отправления: