Re: find all tables with a specific column name?

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

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