Re: How to reference a DB with a period in its name ?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to reference a DB with a period in its name ?
Date: 2024-03-29 22:52:56
Message-ID: d1be0805-c301-4919-8d9b-9238803a03ad@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2024-03-30 03:33:42 Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe
Previous Message Flavious Kumfa 2024-03-29 22:04:34 Re: PostgreSQL hardening best practice