From: John van Zantvoort <snl.jydawg@gmail.com>
To: pgsql-sql@postgresql.org
Subject: obtaining column names from tables or views
Date: Wed, 28 Nov 2007 16:13:16 +0100
Message-ID: <872c5faa0711280713t4627c24fj2992abe1487df9ed@mail.gmail.com> (raw)
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.
Currently I execute the querie and collect the columns but this is rather
expensive, silly and fails when the table or view is empty.
--
Met vriendelijke groeten/with kind regards
John van Zantvoort
---
Most burning issues generate far more heat than light.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCM d-- s:+ a C++ UL++++ P+++ L++ E--- W++ N+ o-- K- w
O M- V- PS+ PE- Y PGP++ t 5 X R- tv- b+ DI+ D+
G e h--- r++ y++
------END GEEK CODE BLOCK------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: snl.jydawg@gmail.com
Subject: Re: obtaining column names from tables or views
In-Reply-To: <872c5faa0711280713t4627c24fj2992abe1487df9ed@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox