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
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 |