Postgres Pro
Downloads
Home   >   mailing lists

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

From Jan Wieck
Subject Re: How to reference a DB with a period in its name ?
Date
Msg-id 2cbb92f7-67d9-41c3-ba57-135a389204cb@wi3ck.info
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
Tree view 
On 3/29/24 17:16, David Gauthier 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).

SELECT * FROM "thedb.v1".theschem.thetab;

Just as documented.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: how to check if the license is expired.
Next
From: Adrian Klaver
Date:
Subject: Re: Query on Postgres SQL transaction