From: Amn Ojee Uw <amnojeeuw@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: PSQL = Yes ... JDBC = no ??
Date: Sun, 3 Sep 2023 18:25:25 -0400
Message-ID: <c49fdab5-a81c-63b0-06e8-d34e16800a34@gmail.com> (raw)
In-Reply-To: <9524571e-96ed-15f0-4f70-89d9bbe273b9@aklaver.com>
References: <cbe8bd8f-7d34-29b3-a169-9cefb9f1de83@gmail.com>
<9524571e-96ed-15f0-4f70-89d9bbe273b9@aklaver.com>
Thanks Adrian, I did read the link you suggested.
I was had at the Introduction title, since it makes this mention
"/Alternatively, input can be from a file or from command line
arguments./" since the input would be from the back end of the database,
as I am using Java DBC to access the database.
However, I have not been able to discern the correlation that exist
between the*JDBC statement *and the definition of *gexec* [/Sends the
current query buffer to the server, then treats each column of each row
of the query's output (if any) as an SQL statement to be executed./]
I guess it is that I am so new to the world of PG-15 that I just cannot
understand or get your point. My reality is that esoteric definition go
right over my head, since I am a newbie.
Would you be able to make the appropriate corrections to the
PostgreSQL-15 schema passed to the JDBC Statement.executeUpdate() method?
Thanks in advance.
PD:
Are you saying that JDBC cannot handle or process \gexec, since it is
PG-15 exclusive?
On 9/3/23 12:04 p.m., Adrian Klaver wrote:
> On 9/3/23 09:00, Amn Ojee Uw wrote:
>> Hello!
>>
>> This issue really puzzles me beyond intrigue.
>>
>> Why would this schema:
>> *SELECT 'CREATE DATABASE jme_test_database' WHERE NOT EXISTS (SELECT
>> FROM pg_database WHERE datname = 'jme_test_database')\gexec*
>> work when entered at the psql prompt, but not when passed as a
>> parameter in a JDBC method?
>>
>> The bellow snip demonstrates the the creation of a String object with
>> same character string used in the PSQL#.
>> //CREATE DATABASE IF NOT EXISTS
>> //~~~~~~~~~~~~~~~~~~
>> *var s = new ***myString*(SELECT 'CREATE DATABASE jme_test_database'
>> WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname =
>> 'jme_test_database')\gexec);**
>
>
> \gexec is a psql specific meta-command.
>
> See Meta-Commands here:
>
> https://www.postgresql.org/docs/current/app-psql.html
>
>
>>
>> Any help would be very much appreciated.
>>
>> Thanks in advance.
>>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: amnojeeuw@gmail.com
Subject: Re: PSQL = Yes ... JDBC = no ??
In-Reply-To: <c49fdab5-a81c-63b0-06e8-d34e16800a34@gmail.com>
References: <cbe8bd8f-7d34-29b3-a169-9cefb9f1de83@gmail.com> <9524571e-96ed-15f0-4f70-89d9bbe273b9@aklaver.com> <c49fdab5-a81c-63b0-06e8-d34e16800a34@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox