On Fri, 21 Apr 2006, Bruno Wolff III wrote:
On Fri, Apr 21, 2006 at 09:29:33 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
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.
Take a look at:
http://developer.postgresql.org/docs/postgres/infoschema-columns.html
Thanks Bruno! It appears I can simply do this:
select table_name from information_schema.columns where column_name =
'last_modified';
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
