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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
