Re: How to reference a DB with a period in its name ? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: How to reference a DB with a period in its name ?
Date
Msg-id BD791A49-083D-4082-BB6E-D2EAA54087D7@thebuild.com
Whole thread Raw
In response to [MASSMAIL]How to reference a DB with a period in its name ?  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general

> On Mar 29, 2024, at 14:16, David Gauthier <dfgpostgres@gmail.com> wrote

> I tried encapsulating the DB name in double quotes (no good), single quotes (still no good) escaping with '\' (no
good),escaping with ".." (no good).  

This is probably more about the string handling in the API you are using than PostgreSQL per se, because enclosing the
individualcomponents in double quotes does indeed work: 

    x.y=# select * from "x.y".s.t;
    i
    ---
    (0 rows)




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to reference a DB with a period in its name ?
Next
From: Jason Long
Date:
Subject: [MASSMAIL]PostgreSQL hardening best practice