From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: prashanth_kamath1@rediffmail.com
Subject: Re: How to incorporate exec sql describe select list
Date: Wed, 12 Feb 2003 09:54:17 +0100
Message-ID: <3E4A0BB9.FDC4A67B@rodos.fzk.de> (raw)
>
> 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.
>
Refer to libpq - C Library within the Client Interfaces section.
Under Command Execution Functions there is a subsection
about Retrieving SELECT Result Information.
This should be what you were asking for.
There is also some C code to refer to. Have a look at the
Example Programs.
Regards, Christoph
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: ch@rodos.fzk.de, prashanth_kamath1@rediffmail.com
Subject: Re: How to incorporate exec sql describe select list
In-Reply-To: <3E4A0BB9.FDC4A67B@rodos.fzk.de>
* 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