How to query for a user-table column name?

From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to query for a user-table column name?
Date: 2008-01-10 17:38:16
Message-ID: 200801101038.16605.kevin@kevinkempterllc.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List;

I'm researching a db and I want to find samples of some of the data. I know
based on the documentation for the proposed "new" schema that the db I have
access to (the "old" schema) probably has a column in one or more of the user
tables called 'region'.

I'm looking for a way to query the system tables to find all user tables with
a column named region. Any thoughts, help?

Thanks in advance..

/Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message marcelo Cortez 2008-01-10 17:38:18 Re: 8.3beta bug or feature?
Previous Message Bricklen Anderson 2008-01-10 17:31:08 Re: 8.2.4 serious slowdown