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

From Rob Sargent
Subject Re: How to reference a DB with a period in its name ?
Date
Msg-id d1be0805-c301-4919-8d9b-9238803a03ad@gmail.com
Whole thread Raw
In response to Re: How to reference a DB with a period in its name ?  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general

On 3/29/24 15:36, David Gauthier wrote:
> 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).
Or is it working, really?  Or are you working around it?




pgsql-general by date:

Previous
From: Flavious Kumfa
Date:
Subject: Re: PostgreSQL hardening best practice
Next
From: Justin Clift
Date:
Subject: Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe