Re: Cross DB query
| От | David G. Johnston |
|---|---|
| Тема | Re: Cross DB query |
| Дата | |
| Msg-id | CAKFQuwaVRoLJoUyHW64eVzwLobRbYMs_Q8J96CXgzbKoJZ4g-Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Cross DB query (Marcos Pegoraro <marcos@f10.com.br>) |
| Список | pgsql-hackers |
On Wednesday, December 8, 2021, Marcos Pegoraro <marcos@f10.com.br> wrote:
A question I always have, and I didn´t find anybody answering it. If it´s possibleselect * 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 connect, using FDW or DBLink, but not why.
Because someone decades ago made that decision and all of the internals rely upon it, making a change cost prohibitive. In short, we allow the syntax because that standard says we should but its not very useful beyond that.
I’m pretty sure I’ve seen this in the documentation but a quick glance didn’t turn it up. Experimentation does prove that it works in this manner though.
David J.
В списке pgsql-hackers по дате отправления: