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

From David Gauthier
Subject Re: How to reference a DB with a period in its name ?
Date
Msg-id CAEs=6Dmg6epZ7FH3aOZY0UncGr8x3=OZ7WLnMHTsOG2P=Qog_Q@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
Ya, I kind of agree on the >1 DB connections not allowed.  It (perl/DBI) does allow for >1 active DB handles (objects).  But of course those handles/objects have different names and that's how to work with the different ones (not a DB prefix like what I have).  Still, it accepted the name in the syntax if it didn't have a ".".  I kinda liked the db prefix because I'm doing these sweeping deletes and I wanted to make extra-sure that I was deleting from the correct DB.

I'm going to ask them to just create another DB without the "." in the name.  All the code has the prefix and I don't want to uproot that (because it's working).

Thanks David ! 

On Fri, Mar 29, 2024 at 5:22 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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: Jason Long
Date:
Subject: [MASSMAIL]PostgreSQL hardening best practice
Next
From: negora
Date:
Subject: Re: How to reference a DB with a period in its name ?