Postgres Pro
Downloads
Home   >   mailing lists

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

From Gavin 'Beau' Baumanis
Subject Find all instances of a column in the entire database.
Date
Msg-id 7D364BC6-BEB4-49E7-B572-B25CBBF1D2DF@eclinic.com.au
Whole thread Raw
Responses Re: Find all instances of a column in the entire database.  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-sql
Tree view 
Hi Everyone,

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.

I was hoping there might be a built-in function for this task, but I  
have been unable to find any information through our good friend Mr.  
Google or by perusing the fine manual.

Thanks in advance for any thoughts you might have.


- Beau

pgsql-sql by date:

Previous
From: "Moiz Kothari"
Date:
Subject: Re: Query tuning
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Find all instances of a column in the entire database.