Friday, May 16, 2008

[SQL] Find all instances of a column in the entire database.

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

No comments: