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

From Erik Jones
Subject Re: Column info without executing query
Date
Msg-id 44C01C14.8000109@myemma.com
Whole thread Raw
In response to Column info without executing query  (Dan Strömberg <dan.stromberg@stockholm.bonet.se>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: calling stored procedure using ECPG
Next
From: Greg Philpott
Date:
Subject: setting serial start value