Column info without executing query

From: Dan Strömberg <dan(dot)stromberg(at)stockholm(dot)bonet(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Column info without executing query
Date: 2006-07-20 18:21:15
Message-ID: 44BFC99B.8050006@stockholm.bonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 information back from the query .

Would something like that be possible in postgres ?

Regards
Dan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-07-20 19:47:35 Re: UTF8 conversion differences from v8.1.3 to v8.1.4
Previous Message Kevin Murphy 2006-07-20 16:25:39 access method "gin" does not exist