Get all table names that have a specific column - Mailing list 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 by date:

Previous
From: Fernando Grijalba
Date:
Subject: Help with inventory control
Next
From: "A. Kretschmer"
Date:
Subject: Re: Get all table names that have a specific column