find all tables with a specific column name?

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: find all tables with a specific column name?
Date: 2006-04-21 16:29:33
Message-ID: Pine.LNX.4.64.0604210928220.1527@glacier.frostconsultingllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a reasonable way to extract a list of all tables which contain a
specific column name from the system views on 8.1?

For instance, I might want to enumerate all tables with a column named
last_modified.

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2006-04-21 18:03:56 Re: find all tables with a specific column name?
Previous Message Tom Lane 2006-04-21 14:38:02 Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3