Обсуждение: Explain SQL feature

I have written a script-driven database tool able to reverse engineer,
diagnose, and display as a network layout group database objects (see
www.seabirdsoftware.com), for SQL databases including postgres. One of
the features I support is the explain plan SQL feature. I create an ADO
record set from a SQL statement (such as 'explain select * from [..]')
and I expect a record set in return.
.. Except that no record set is returned. This is working (of course)
under psql.

Any hint...? Thank you...!

- Regis
regis@seabirdsoftware.com
www.seabirdsoftware.com

Regis <regis@seabirdsoftware.com> writes:
> the features I support is the explain plan SQL feature. I create an ADO
> record set from a SQL statement (such as 'explain select * from [..]')
> and I expect a record set in return.

Explain's output comes back as a NOTICE message, not as a recordset.

            regards, tom lane