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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Gavin 'Beau' Baumanis <gavinb(at)eclinic(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Find all instances of a column in the entire database.
Date: 2008-05-16 13:56:51
Message-ID: 20080516135651.GA9173@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 Gavin 'Beau' Baumanis 2008-05-16 14:04:05 Re: Find all instances of a column in the entire database.
Previous Message Gavin 'Beau' Baumanis 2008-05-16 13:51:20 Find all instances of a column in the entire database.