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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1rqK84-00BjVt-NV
	for pgsql-general@arkaria.postgresql.org; Fri, 29 Mar 2024 21:51:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1rqK83-004ltm-Rb
	for pgsql-general@arkaria.postgresql.org; Fri, 29 Mar 2024 21:51:15 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <public@negora.com>)
	id 1rqK83-004ltW-FY
	for pgsql-general@lists.postgresql.org; Fri, 29 Mar 2024 21:51:15 +0000
Received: from smtp-relay-01-8.dondominio.net ([31.214.176.31])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <public@negora.com>)
	id 1rqK7n-0077Ct-0j
	for pgsql-general@lists.postgresql.org; Fri, 29 Mar 2024 21:51:14 +0000
Received: from localhost (smtp-relay-local.scip.local [127.0.0.1])
	by smtp-relay.dondominio.com (Postfix) with SMTP id 3702B40647
	for <pgsql-general@lists.postgresql.org>;
 Fri, 29 Mar 2024 22:50:54 +0100 (CET)
Received: from mail-node.dondominio.com
	by smtp-relay.dondominio.com (Postfix) with ESMTP id 093464062A;
	Fri, 29 Mar 2024 22:50:53 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=negora.com; s=dddk;
	t=1711749053; bh=SsqzO11xYfbeED3VUOMH/5wzc8hgrs+YQI/KsowT3RQ=;
	h=Content-Type:Message-ID:Date:Subject:To:From;
	b=hUZxccFlDlkJmgciAlHg4u3S8amtsW8xv+1QEjFxfoYTT6/udUeAR3r6R1JYE11Jh
	 xf+GJuLGcsrzdQLHQZ2pAhXg5OqXmCuigzJjylT2hJDYUzh1J2evrvPONGMMbXxaiL
	 EhtWrnkpcmQNYiFkjIUhZtpq0+571XBNWb6K4rgs=
Received: from [192.168.24.5] (4.red-83-58-241.dynamicip.rima-tde.net
 [83.58.241.4])
	(Authenticated sender: public@negora.com)
	by mail-node.dondominio.com (Postfix) with ESMTPA id CD2E8401DF;
	Fri, 29 Mar 2024 22:50:52 +0100 (CET)
Content-Type: multipart/alternative;
 boundary="------------L1GdhMXTeLQ0NFyU9zbBYAIg"
Message-ID: <36cef37d-32cf-45f4-a4ce-01dc29cad5e1@negora.com>
Date: Fri, 29 Mar 2024 22:50:52 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: How to reference a DB with a period in its name ?
To: David Gauthier <dfgpostgres@gmail.com>
References: 
 <CAEs=6DniFeqNT6RHCcPiiFFWzTGzQKMKboNch72Ftadr_W-Cdw@mail.gmail.com>
Content-Language: en-US, es-ES, en-GB
Cc: pgsql-general@lists.postgresql.org
From: negora <public@negora.com>
In-Reply-To: 
 <CAEs=6DniFeqNT6RHCcPiiFFWzTGzQKMKboNch72Ftadr_W-Cdw@mail.gmail.com>
X-Greylist: Sender succeeded SMTP AUTH,
 not delayed by milter-greylist-4.6.2 (mail-node.dondominio.com [0.0.0.0]);
 Fri, 29 Mar 2024 22:50:52 +0100 (CET)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/36cef37d-32cf-45f4-a4ce-01dc29cad5e1%40negora.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------L1GdhMXTeLQ0NFyU9zbBYAIg
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi:

I think your problem is in the Perl side more than in PostgreSQL's. When 
you said you tried escaping with \, Did you mean *exactly* this?

    "delete from \"thedb.v1\".theschem.thetab where col1 = 1"

I think this should work.

Or you can use single quotes to enclose the query, so that you don't 
need to escape the double quotes:

    'delete from "thedb.v1".theschem.thetab where col1 = 1'

Best regards.


On 29/03/2024 22:16, David Gauthier wrote:
> Hi:
>
> I have a DB named "thedb", which has a schema called "theschem" which 
> has a table called "thetab".  In a perl/DBI script, I am able to work 
> with the table by referencing it as... "thedb.theschem.thetab" as 
> in... "delete from thedb.theschem.thetab where col1=1"
>
> No problem (so far...)
>
> New DB now has a name "thedb.v1" (notice the "."), the schem and table 
> are the same as above.  But now I'm getting a syntax error presumably 
> because of that "." introduced in the DB name.
>
> I tried encapsulating the DB name in double quotes (no good), single 
> quotes (still no good) escaping with '\' (no good), escaping with ".." 
> (no good).
>
> Is there a way I can reference the DB which has the "." in it's name ?
>
> v11.5 on linux (I know, way past time to upgrade)
>
> Thanks in Advance !
--------------L1GdhMXTeLQ0NFyU9zbBYAIg
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <style>#CustomCSS-add-on-marker{}
.code {
    padding: 0.00em 0.30em 0.00em 0.30em;
    background-color: #ebf6e8;
    color: #003a0f;
    font-family: "DejaVu Sans Mono", monospace;
    font-size: 1.00em;
}
.code a:link {
    color: #003a0f;
    text-decoration: underline;
}
</style>
  </head>
  <body>
    <p>Hi:<br>
    </p>
    <p>I think your problem is in the Perl side more than in
      PostgreSQL's. When you said you tried escaping with <span
        class="code">\</span>, Did you mean <b>exactly</b> this?<br>
    </p>
    <blockquote>
      <p></p>
    </blockquote>
    <blockquote>
      <p><span class="code">"delete from \"thedb.v1\".theschem.thetab
          where col1 = 1"</span></p>
    </blockquote>
    <p>I think this should work.</p>
    <p>Or you can use single quotes to enclose the query, so that you
      don't need to escape the double quotes:</p>
    <blockquote>
      <p><span class="code">'delete from "thedb.v1".theschem.thetab
          where col1 = 1'</span></p>
    </blockquote>
    <p>Best regards.</p>
    <p><br>
    </p>
    <p></p>
    <div class="moz-cite-prefix">On 29/03/2024 22:16, David Gauthier
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAEs=6DniFeqNT6RHCcPiiFFWzTGzQKMKboNch72Ftadr_W-Cdw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hi:
        <div><br>
        </div>
        <div>I have a DB named "thedb", which has a schema called
          "theschem" which has a table called "thetab".  In a perl/DBI
          script, I am able to work with the table by referencing it
          as... "thedb.theschem.thetab" as in... "delete from
          thedb.theschem.thetab where col1=1"</div>
        <div><br>
        </div>
        <div>No problem (so far...)</div>
        <div><br>
        </div>
        <div>New DB now has a name "thedb.v1" (notice the "."), the
          schem and table are the same as above.  But now I'm getting a
          syntax error presumably because of that "." introduced in the
          DB name.</div>
        <div><br>
        </div>
        <div>I tried encapsulating the DB name in double quotes (no
          good), single quotes (still no good) escaping with '\' (no
          good), escaping with ".." (no good). </div>
        <div><br>
        </div>
        <div>Is there a way I can reference the DB which has the "." in
          it's name ?<br>
          <br>
          v11.5 on linux (I know, way past time to upgrade)<br>
          <br>
          Thanks in Advance !</div>
      </div>
    </blockquote>
  </body>
</html>

--------------L1GdhMXTeLQ0NFyU9zbBYAIg--