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

On Fri, 21 Apr 2006, Bruno Wolff III wrote:

> On Fri, Apr 21, 2006 at 09:29:33 -0700,
>  Jeff Frost <jeff@frostconsultingllc.com> 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     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954