Postgres Pro
Downloads
Home   >   mailing lists

Re: Parse a statement, get parameter types and return types - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Parse a statement, get parameter types and return types
Date
Msg-id 2839.1121695124@sss.pgh.pa.us
Whole thread Raw
In response to Parse a statement, get parameter types and return types  (Richard Jones <rich@annexia.org>)
Responses Re: Parse a statement, get parameter types and return types
List pgsql-interfaces
Tree view 
Richard Jones <rich@annexia.org> writes:
> Given a statement, eg:
>   select foo from bar where col = $1

> I'd really like to get the types deduced by the PostgreSQL parser for
> the input variables ($1, etc.) and the result column(s).

This is possible at the protocol level -- see Describe Statement.
I'm not sure which client libraries let you get at the results ...
libpq isn't one of them :-(
        regards, tom lane

pgsql-interfaces by date:

Previous
From: Zahid Khan
Date:
Subject: info required about Dot net DataProvider
Next
From: Richard Jones
Date:
Subject: Re: Parse a statement, get parameter types and return types