Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qcpWi-001L4O-UU for pgsql-general@arkaria.postgresql.org; Sun, 03 Sep 2023 16:00:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qcpWg-003bzI-Qk for pgsql-general@arkaria.postgresql.org; Sun, 03 Sep 2023 16:00:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qcpWg-003bz8-Ev for pgsql-general@lists.postgresql.org; Sun, 03 Sep 2023 16:00:38 +0000 Received: from mail-qv1-xf2e.google.com ([2607:f8b0:4864:20::f2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qcpWd-002laZ-G1 for pgsql-general@lists.postgresql.org; Sun, 03 Sep 2023 16:00:37 +0000 Received: by mail-qv1-xf2e.google.com with SMTP id 6a1803df08f44-64c5f5d6f04so4494916d6.3 for ; Sun, 03 Sep 2023 09:00:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693756833; x=1694361633; darn=lists.postgresql.org; h=subject:to:content-language:user-agent:mime-version:date:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=hM/0LcarrWT4P3isW1Zt8dLOIUccXd16IS+jQe2NoBI=; b=szGPHb77uLg4ALLw7TL5U4Dx8aZiTkybcBgLVxM46f982kwF5T5hUdNlKCTd97S+QD Z6V/mdbSRqW5YrweryuUpEiX45l7iuK5crSf0yQjwnvKO6X7OU9bVTCwLkn1rzhZnvpE 0OFQZMv4weOMeGy171aYuV+TCs91yxD265AiUoDZhfZWv08iMiLt8RrvDsYA2kvGQ2uX XCjYVSNJmMIYlbSG6SH3wgla2DkQBF4N3M9BlTs2iwC9GhigooZX+MP46T1XEtyXL3Vg H/BCukgxfTThInMcEQ4KPEWBNCEaNYRnFYaTjFKKZt2Ksj3ZbB5tdQZEi8ge6j8g0+PN Bx8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693756833; x=1694361633; h=subject:to:content-language:user-agent:mime-version:date:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=hM/0LcarrWT4P3isW1Zt8dLOIUccXd16IS+jQe2NoBI=; b=dIh8GH/g9VUXPEOJKvqFfFJXrqCck1kiyPHTzjM9wEygOokv5x5Dl+8OEwm6l8O71D uOGfb/q3adMUO+IqZpH2Zqyq1sRM9mAjqpt2Yviy10fuM+7sa2yc1Dtyap0ZWWG5ZAx2 mwuXKclGv8vSi+aN1bQ3ZQADtQch9iSCRE8YpjI1nSpsL38bFjIEYipgGse4YlB1hzfi cDYOBhPsIDQMzdhn8l4R2YhGvY1PfEcOvprjpFpJoLzoyoypW+z28WVZqJn7taHRnKsG h26ohIwJJH10eStsoY6NUf+nvz0Xs6tKdeKQsn7unjAqYChBsDhKUXZpcvQ8TUYV/X5V yPQQ== X-Gm-Message-State: AOJu0YyfjmD/atDyfnp5V2Sp1Lp/MvnTbjKc0aBLBq9V0eVgF/p2Lq8P MKYshSFQrCHgqQFopr1w2lKRVTL0Pcs= X-Google-Smtp-Source: AGHT+IEZUIhqmhuwC1c99AGFlVR/Pa5jOfcqLgNJ9v5k4zZQ9RO+eQdHb7yz75Gy4BqzEK06FIYkDQ== X-Received: by 2002:a0c:8d47:0:b0:64c:4738:a0e2 with SMTP id s7-20020a0c8d47000000b0064c4738a0e2mr6326930qvb.14.1693756832995; Sun, 03 Sep 2023 09:00:32 -0700 (PDT) Received: from [192.168.2.170] ([67.70.150.114]) by smtp.gmail.com with ESMTPSA id z3-20020a0cda83000000b0064f70c57531sm2932524qvj.57.2023.09.03.09.00.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 03 Sep 2023 09:00:32 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Content-Type: multipart/alternative; boundary="------------Cf09aJgjKLxmbbhFi0V3mrHg" Message-ID: Date: Sun, 3 Sep 2023 12:00:22 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.14.0 Content-Language: en-CA, es-ES To: pgsql-general@lists.postgresql.org Subject: PSQL = Yes ... JDBC = no ?? List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Cf09aJgjKLxmbbhFi0V3mrHg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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);** ** **stmt.executeUpdate(s.toString());* However, this time PostgreSQL-15 complains with an error message saying : *Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"** **  Position: 122 * For better clarification, I'd like to show the code to create the schema inside Java/JDBC. ---- snip ----  */    ...     var sv = myString();     ...     public final myString getCreateDatabase(myString s){         this.sv.setData("SELECT 'CREATE DATABASE ");         this.sv.append(s.toString());         this.sv.append("\'");         this.sv.append("WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = ");         this.sv.append("\'");         this.sv.append(s.toString());         this.sv.append("\'");         this.sv.append(")\\gexec");         return sv;     } Any help would be very much appreciated. Thanks in advance. --------------Cf09aJgjKLxmbbhFi0V3mrHg Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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);

stmt.executeUpdate(s.toString());

However, this time PostgreSQL-15 complains with an error message saying :

Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"
  Position: 122

For better clarification, I'd like to show the code to create the schema inside Java/JDBC.
---- snip ----

 */
   ...

    var sv = myString();
    ...

    public final myString getCreateDatabase(myString s){
        this.sv.setData("SELECT 'CREATE DATABASE ");
        this.sv.append(s.toString());
        this.sv.append("\'");
        this.sv.append("WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = ");
        this.sv.append("\'");
        this.sv.append(s.toString());
        this.sv.append("\'");
        this.sv.append(")\\gexec");

        return sv;
    }


Any help would be very much appreciated.

Thanks in advance.

--------------Cf09aJgjKLxmbbhFi0V3mrHg--