Re: Cross DB query

2021-12-08 Thread David G. Johnston
On Wednesday, December 8, 2021, Marcos Pegoraro wrote: > A question I always have, and I didn´t find anybody answering it. If it´s > possible > select * from MyDB.MySchema.MyTable; > No, if you specify MyDB is must match the database you’ve chosen to log into. > Everything I found was how to c

Cross DB query

2021-12-08 Thread Marcos Pegoraro
A question I always have, and I didn´t find anybody answering it. If it´s possible select * from MyDB.MySchema.MyTable; And from user point of view ... all databases are accessible for the same postgres instance, user just says connect to this or that database, why is it not possible to do select