Re: JDBC

On Sunday, June 10, 2018, Chuck Davis <cjgunzel(at)gmail(dot)com> wrote:

> If I try to return a ResultSet the class will not compile with the
> message that boolean cannot be converted to a ResultSet. And this is
> in synch with the documentation that states the "exists" subquery will
> return a boolean -- not a ResultSet.
>
>
The PostgreSQL documentation doesn't talk in terms JDBC, the Oracle JDBC
API specification covers that.

https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html

JDBC uses ResultSet to return the results of queries.

> There are a number of sites that indicate the statement is the way to
> find out if a table exists. Are the sites for an older version of PG?
> I'm running on 10.
>

This really has nothing to do with PostgreSQL specifically, you are failing
to use the JDBC API correctly. In the short term you should probably just
use "executeQuery" instead of "execute" since you are in fact executing a
query that returns a ReaultSet (which is exactly what execute's true
boolean result is telling you).

David J.