Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: How to reference a DB with a period in its name ?
Date
Msg-id CAKFQuwbSsRU=yYwR7k9ituWTj_D+A8+rxiRWgq03o990GcfDVA@mail.gmail.com
Whole thread Raw
In response to Re: How to reference a DB with a period in its name ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to reference a DB with a period in its name ?
List pgsql-general
Tree view
On Fri, Mar 29, 2024 at 2:20 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Mar 29, 2024 at 2:16 PM David Gauthier <dfgpostgres@gmail.com> wrote:
I tried encapsulating the DB name in double quotes (no good)

This is what the documentation says you are supposed to do for non-simple identifiers so you need to show your work to understand where you went wrong.


Actually, you really aren't supposed to put the database name in there at all; it's pointless since there is no ability to reference a database other than the one you are connected to.

David J.

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: Christophe Pettus
Date:
Subject: Re: How to reference a DB with a period in its name ?