EXPLAIN via jdbc

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: EXPLAIN via jdbc
Date: 2002-08-08 09:16:06
Message-ID: 00c401c23ebc$39bf7e60$0100a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jochem van Dieten 2002-08-08 13:15:44 Re: EXPLAIN via jdbc
Previous Message Daniel.Stoinski 2002-08-08 07:20:52 PL/pgSQL and JDBC, Relation 'Number' does not exist