How to get a list of tables that have a particular column value?

From: "Rajan, Pavithra " <RAJANP(at)coned(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to get a list of tables that have a particular column value?
Date: 2009-12-23 17:15:55
Message-ID: BE29E09321056B4C9082D207759A692801DADB3A@EXCHMB01.conedison.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello - I would like to know if there is a way to find all the table
names in a data base that have a particular column value eg:"volt" .ie
given a column value (not column name) how to I find which tables and
their column names have them .Thank you.

Pavithra Rajan
<mailto:rajanp(at)coned(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christine Penner 2009-12-23 18:00:26 Re: Simple function
Previous Message Richard Broersma 2009-12-23 17:15:33 Re: Simple function