Re: Function for retreiving datatype

On Tue, Jan 11, 2005 at 08:29:33AM +1100, Brendan Jurd wrote:

> My post was all about finding out whether postgres has this
> functionality.

Certainly PostgreSQL provides a way to discover a row's column
types, but how to do it depends on where you're trying to do it
from.  If you're writing a client program in C using libpq, you
could use the functions documented under "Retrieving Query Result
Information" in the "Command Execution Functions" section of the
libpq chapter of the documentation.  If you're writing a client
program using ECPG then you could use a descriptor area.  If you're
writing a server-side C program that makes queries via SPI then you
could use the functions defined under "Interface Support Functions"
in the "Server Programming Interface" chapter.

Is that what you're looking for?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/