Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: obtaining column names from tables or views
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: John van Zantvoort <snl(dot)jydawg(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: obtaining column names from tables or views
- Date: Wed, 28 Nov 2007 15:29:23 +0000
John van Zantvoort wrote:
moin, I've got a question. I'm scripting against an existing postgresql database environment and need to tweak queries based on the columns in the views or tables, how can if find these w/o querying the tables or views.
There is a whole section of the manual devoted to the system catalogues: http://www.postgresql.org/docs/8.2/static/catalogs.htmlOr there's the "information schema" which is in a standardised layout but doesn't include PG-specific details.
http://www.postgresql.org/docs/8.2/static/information-schema.html -- Richard Huxton Archonet Ltd
- References:
- obtaining column names from tables or views
- From: John van Zantvoort
- obtaining column names from tables or views
- Prev by Date: obtaining column names from tables or views
- Next by Date: Re: NULLIF problem
- Previous by thread: obtaining column names from tables or views
- Next by thread: statement-level trigger sample out there?
- Indexes: