Re: Column info without executing query

Dan Strömberg wrote:
> Hi List !
>
> 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 ?
Well for result sets of queries on tables there is always the
pg_attribute catalog table.

See:
http://www.postgresql.org/docs/8.1/interactive/catalog-pg-attribute.html

--
erik jones <erik@myemma.com>
software development
emma(r)