Re: Parse a statement, get parameter types and return types

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