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

gavinb(at)eclinic(dot)com(dot)au ("Gavin 'Beau' Baumanis") writes:
> 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.

I have a schema which has a number of attributes called "name_id":

metadata=# select n.nspname, r.relname from pg_class r, pg_namespace n, pg_attribute a where a.attname = 'name_id' and r.oid = attrelid and n.oid = relnamespace;
nspname | relname
----------+---------------------
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
registry | redacted
(23 rows)

Change 'name_id' to 'myColumnName' and you should get what you're
expecting...
--
"cbbrowne","@","acm.org"
http://cbbrowne.com/info/lsf.html
Signs of a Klingon Programmer - 17. "Klingon multitasking systems do
not support "time-sharing". When a Klingon program wants to run, it
challenges the scheduler in hand-to-hand combat and owns the machine."