[EMAIL PROTECTED] ("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." -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
