[GENERAL] Column info without executing query

2006-07-20 Thread Dan Strömberg
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 ? I know there is something like that in MS SQL Server where you can use the SET FMTONLY option and only get the column informati

Re: [GENERAL] Column info without executing query

2006-07-21 Thread Dan Strömberg
I found pg_prog.prorettype in the system catalogs , is it possible to use that to find the resultset datatypes of a set returning function ? Anyway , maybe the odbc driver will work by using SQLDescribecol() without executing it ?! I found something in the archives where someone suggests that