Re: Find all instances of a column in the entire database.

From: Gavin 'Beau' Baumanis <gavinb(at)eclinic(dot)com(dot)au>
To: depesz(at)depesz(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Find all instances of a column in the entire database.
Date: 2008-05-16 14:04:05
Message-ID: FC081007-9536-4187-B14F-35C8E7A00A9F@eclinic.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2008-05-16 14:27:09 Re: Find all instances of a column in the entire database.
Previous Message hubert depesz lubaczewski 2008-05-16 13:56:51 Re: Find all instances of a column in the entire database.