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'