Re: Column info without executing query

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.