Postgres Pro
Downloads
Home   >   mailing lists

Re: Find all instances of a column in the entire database. - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject Re: Find all instances of a column in the entire database.
Date
Msg-id 20080516135651.GA9173@depesz.com
Whole thread Raw
In response to Find all instances of a column in the entire database.  (Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>)
Responses Re: Find all instances of a column in the entire database.  (Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>)
List pgsql-sql
Tree view 
On Fri, May 16, 2008 at 11:51:20PM +1000, Gavin 'Beau' Baumanis wrote:
> I am hoping that you might be able to give me some assistance with the  
> following task!
> I have a database with nearly 200 tables and I need to find all tables  
> that contain a column of myColumnName.

select * from information_schema.columns where column_name = 'myColumnName';

depesz

pgsql-sql by date:

Previous
From: Gavin 'Beau' Baumanis
Date:
Subject: Find all instances of a column in the entire database.
Next
From: Gavin 'Beau' Baumanis
Date:
Subject: Re: Find all instances of a column in the entire database.