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

Hi depesz,

Thanks very much!
That works wonderfully well...

Is this listed in the manual anywhere? because after two hours of  
reading, I didn't find it anywhere!

None the less - thanks again.


- Beau


On 16/05/2008, at 11:56 PM, hubert depesz lubaczewski wrote:

> 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