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.
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
Hi:
I think your problem is in the Perl side more than in PostgreSQL's. When
you said you tried escaping with \, Did you mean *exactly* this?
"delete from \"thedb.v1\".theschem.thetab where col1 = 1"
I think this should work.
Or you can use single quotes to enclose the query, so that you
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 sy
> On Mar 29, 2024, at 14: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).
This is probably more about the string handling in the API you are using than
Postgre
On Fri, Mar 29, 2024 at 2:20 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Fri, Mar 29, 2024 at 2:16 PM David Gauthier
> 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
> ide
On Fri, Mar 29, 2024 at 2:16 PM David Gauthier
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.
David J.
Hi:
I have a DB named "thedb", which has a schema called "theschem" which has a
table called "thetab". In a perl/DBI script, I am able to work with the
table by referencing it as... "thedb.theschem.thetab" as in... "delete from
thedb.theschem.thetab where col1=1"
No problem (so far...)
New DB n