How to incorporate exec sql describe select list ( available in sql server in postgres)

From: "Prashanth - Kamath" <prashanth_kamath1(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to incorporate exec sql describe select list ( available in sql server in postgres)
Date: 2003-02-12 06:23:13
Message-ID: 20030212062313.19068.qmail@webmail27.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Alessandro Pedrotti 2003-02-12 07:49:11 R: adding not null constraints on columns
Previous Message Tom Lane 2003-02-12 06:18:45 Re: adding not null constraints on columns