Re: EXPLAIN via jdbc - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: EXPLAIN via jdbc
Date
Msg-id 1028813007.1888.76.camel@inspiron.cramers
Whole thread Raw
In response to Re: EXPLAIN via jdbc  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-jdbc
The notices should be in the warnings, you may need to use the
development version of the driver for this to be true.

Dave
On Thu, 2002-08-08 at 09:15, Jochem van Dieten wrote:
> Michael Paesold wrote:
> > 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?
>
> If I read the development documentation correctly, the next version of
> PostgreSQL will return EXPLAIN output as a recordset instead of a NOTICE.
>
> HTH,
> Jochem
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>




pgsql-jdbc by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: EXPLAIN via jdbc
Next
From: Barry Lind
Date:
Subject: Re: [ADMIN] Connecting via SSL not working (except from psql)