Re: Get all table names that have a specific column
| От | Doug Bloebaum |
|---|---|
| Тема | Re: Get all table names that have a specific column |
| Дата | |
| Msg-id | caa2de8a0509300841v73233b9fhfa85bab72ba3d0d@mail.gmail.com обсуждение исходный текст |
| Ответ на | Get all table names that have a specific column (Emi Lu <emilu@cs.concordia.ca>) |
| Список | pgsql-general |
On 9/30/05, Emi Lu <emilu@cs.concordia.ca> wrote:
> 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".
I'd use:
select table_name
from information_schema.columns
where table_schema='my_schema'
and column_name='col1'
Lots of good info here: http://www.postgresql.org/docs/7.4/static/information-schema.html
> 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".
I'd use:
select table_name
from information_schema.columns
where table_schema='my_schema'
and column_name='col1'
Lots of good info here: http://www.postgresql.org/docs/7.4/static/information-schema.html
On 9/30/05, Emi Lu <emilu@cs.concordia.ca> wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
В списке pgsql-general по дате отправления: