Re: JDBC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chuck Davis <cjgunzel(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC
Date: 2018-06-10 20:40:46
Message-ID: 22547.1528663246@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Chuck Davis <cjgunzel(at)gmail(dot)com> writes:
> I created a new, empty database and I want to test whether a table
> exists or not.

Are you sure the DB is in fact empty?

> The only thing I can think of is that the information_schema is
> actually for the cluster.

It is not.

> I have other databases in the cluster that
> do have an entities table.

I'm betting that you created such a table in template1, so that it's
getting cloned into new databases by CREATE DATABASE.

regards, tom lane

In response to

  • Re: JDBC at 2018-06-10 20:24:55 from Chuck Davis

Responses

  • Re: JDBC at 2018-06-10 23:05:37 from Chuck Davis

Browse pgsql-jdbc by date

  From Date Subject
Next Message David G. Johnston 2018-06-10 20:44:25 Re: JDBC
Previous Message Chuck Davis 2018-06-10 20:24:55 Re: JDBC