Postgres Pro
Downloads
Home   >   mailing lists

find all tables with a specific column name? - Mailing list pgsql-sql

From Jeff Frost
Subject find all tables with a specific column name?
Date
Msg-id Pine.LNX.4.64.0604210928220.1527@glacier.frostconsultingllc.com
Whole thread Raw
Responses Re: find all tables with a specific column name?  (Bruno Wolff III <bruno@wolff.to>)
Re: find all tables with a specific column name?  (George Young <gry@ll.mit.edu>)
List pgsql-sql
Tree view 
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@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3
Next
From: Bruno Wolff III
Date:
Subject: Re: find all tables with a specific column name?