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  ("A. Kretschmer" <akretschmer@despammed.com>)
Re: Get all table names that have a specific column  (Bricklen Anderson <BAnderson@PresiNET.com>)
Re: Get all table names that have a specific column  (Doug Bloebaum <blabes@gmail.com>)
Re: Get all table names that have a specific column  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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 по дате отправления:

Предыдущее
От: Fernando Grijalba
Дата:
Сообщение: Help with inventory control
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Get all table names that have a specific column