Re: PSQL = Yes ... JDBC = no ?? - Mailing list pgsql-general

From Amn Ojee Uw
Subject Re: PSQL = Yes ... JDBC = no ??
Date
Msg-id 5dc2926b-32d6-dce7-49e6-aee508ce73c3@gmail.com
Whole thread Raw
In response to Re: PSQL = Yes ... JDBC = no ??  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: PSQL = Yes ... JDBC = no ??
List pgsql-general

I see now, any suggestions as work around in JDBC?

Thanks!!

On 9/3/23 8:12 p.m., David G. Johnston wrote:
On Sunday, September 3, 2023, Amn Ojee Uw <amnojeeuw@gmail.com> wrote:

Are you saying that JDBC cannot handle or process \gexec, since it is PG-15 exclusive?


psql is a client application present in all versions of PostgreSQL.  It has a bunch of features related to executing SQL queries.  The stuff that it is documented to do are only doable by it in many cases, and in all cases are done locally, not by the server.  You cannot send those meta-commands to the server, it has no clue what to do with them.  And since you are using JDBC you by definition aren’t using psql.

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PSQL = Yes ... JDBC = no ??
Next
From: Erik Wienhold
Date:
Subject: Re: createuser unexpectedly creates superuser with createdb and createrole