Explain SQL feature

Started by Regisabout 24 years ago2 messagesgeneral
Jump to latest
#1Regis
regis@seabirdsoftware.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Regis (#1)
Re: Explain SQL feature

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