Re: Column info without executing query - Mailing list pgsql-general

From Jacob Coby
Subject Re: Column info without executing query
Date
Msg-id 44C0D052.2090405@listingbook.com
Whole thread Raw
In response to Re: Column info without executing query  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Responses Re: Column info without executing query  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
List pgsql-general
Volkan YAZICI wrote:
> On Jul 20 08:21, Dan Strömberg wrote:
>> I would like to know if it is possible to find out the datatypes in the
>> resultset of a query or a set returning
>> function without actually executing them ?
>
> As Tom mentioned, there's support for this feature in the protocol
> level, but I don't know any API supports this yet. However, here's a
> patch that adds Describe functionality for Prepared Statements and
> Cursors to libpq:
> http://archives.postgresql.org/pgsql-hackers/2006-06/msg01281.php

PHP supports it with the pg_field_type() function.


pgsql-general by date:

Previous
From: Claire McLister
Date:
Subject: Re: Create index hanging
Next
From: Volkan YAZICI
Date:
Subject: Re: Column info without executing query