From: Prashanth - Kamath <prashanth_kamath1@rediffmail.com>
To: pgsql-sql@postgresql.org
Subject: How to incorporate exec sql describe select list ( available in sql server in postgres)
Date: 12 Feb 2003 06:23:13 -0000
Message-ID: <20030212062313.19068.qmail@webmail27.rediffmail.com> (raw)
Hi,
I have requirement where for a select statement i need dbms column
information like data type,precision,scale, length etc
In Oracle using "exec sql describe select list ..." it is possible
to obtain the above information. In postgres descriptor is
avaialble only after fetching from the cursor. This is not
possbile through ecpg programming. But i was thinking whether it
is possible to do with libpq programming. If so can anyone send me
pointer to the code.
Regards
Prashanth Kamath
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: prashanth_kamath1@rediffmail.com
Subject: Re: How to incorporate exec sql describe select list ( available in sql server in postgres)
In-Reply-To: <20030212062313.19068.qmail@webmail27.rediffmail.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