Hi,
we are currently evaluating postgres for a commercial project. To get a clue
about how well the jdbc driver works for us, I wrote a simple java app that
can display query results.
Then I tried to add EXPLAIN support to it, so I could see the result of
EXPLAIN SELECT * ... simultaniously. That is when I got stuck.
I can't find a way to get the result from EXPLAIN queries through jdbc. I
first tried to do it by executeQuery("EXPLAIN ..."), but that would not
return a result set. Also using execute() helped, not even getWarnings()
helped..
I there any way to get the result from an EXPLAIN query?
Any help would be appreciated!
Michael
--
Michael Paesold, Austria/Europe