On Jul 20 08:21, Dan Strömberg wrote: > 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 ?
As Tom mentioned, there's support for this feature in the protocol level, but I don't know any API supports this yet. However, here's a patch that adds Describe functionality for Prepared Statements and Cursors to libpq: http://archives.postgresql.org/pgsql-hackers/2006-06/msg01281.php Regards. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster