X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 258CD475A45 for ; Wed, 12 Feb 2003 01:17:51 -0500 (EST) Received: from rediffmail.com (unknown [203.199.83.37]) by postgresql.org (Postfix) with SMTP id 8254C475A1E for ; Wed, 12 Feb 2003 01:17:48 -0500 (EST) Received: (qmail 19069 invoked by uid 510); 12 Feb 2003 06:23:13 -0000 Date: 12 Feb 2003 06:23:13 -0000 Message-ID: <20030212062313.19068.qmail@webmail27.rediffmail.com> Received: from unknown (164.164.86.66) by rediffmail.com via HTTP; 12 feb 2003 06:23:13 -0000 MIME-Version: 1.0 From: "Prashanth - Kamath" Reply-To: "Prashanth - Kamath" To: pgsql-sql@postgresql.org Subject: How to incorporate exec sql describe select list ( available in sql server in postgres) Content-type: text/plain; format=flowed Content-Disposition: inline X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/234 X-Sequence-Number: 11632 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