How to query for a user-table column name? - Mailing list pgsql-general

From Kevin Kempter
Subject How to query for a user-table column name?
Date
Msg-id 200801101038.16605.kevin@kevinkempterllc.com
Whole thread Raw
Responses Re: How to query for a user-table column name?  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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

pgsql-general by date:

Previous
From: marcelo Cortez
Date:
Subject: Re: 8.3beta bug or feature?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: How to query for a user-table column name?