Get all table names that have a specific column
| От | Emi Lu |
|---|---|
| Тема | Get all table names that have a specific column |
| Дата | |
| Msg-id | 433D51F0.3090406@cs.concordia.ca обсуждение исходный текст |
| Ответы |
Re: Get all table names that have a specific column
Re: Get all table names that have a specific column Re: Get all table names that have a specific column Re: Get all table names that have a specific column |
| Список | pgsql-general |
Greetings, I am not very familiar with the system views/tables in postgreSQL. I'd like to get all table names that have a column let's say named "col1". For example, t1 (... col1 varchar(3) ... ) t2 (... col1 varchar(3) ... ) t3 (... ...) After querying the system tables/views, I can get the result something like : tables contain column "col1" --------------------------------------------- t1 t2 (2 rows) Thanks a lot, Emi
В списке pgsql-general по дате отправления: