Can we get SQL Server-like cross database queries

Поиск
Список
Период
Сортировка
Искать
От
Guyren Howe
Тема
Can we get SQL Server-like cross database queries
Дата
Msg-id
84A3D231-6AFB-4981-AA09-18FBC7772B77@gmail.com
Список
Дерево обсуждения
Can we get SQL Server-like cross database queries Guyren Howe <guyren@gmail.com>
Re: Can we get SQL Server-like cross database queries Tom Lane <tgl@sss.pgh.pa.us>
Re: Can we get SQL Server-like cross database queries Rob Sargent <robjsargent@gmail.com>
Re: Can we get SQL Server-like cross database queries Ron <ronljohnsonjr@gmail.com>
Re: Can we get SQL Server-like cross database queries Thomas Munro <thomas.munro@gmail.com>
Re: Can we get SQL Server-like cross database queries Laurenz Albe <laurenz.albe@cybertec.at>
Re: Can we get SQL Server-like cross database queries "David G. Johnston" <david.g.johnston@gmail.com>
Re: Can we get SQL Server-like cross database queries Matt Zagrabelny <mzagrabe@d.umn.edu>
One of the few really useful features of SQL Server that Postgres doesn’t have is straightforward cross-database queries.

You can reference any table in any database on the same server you’re on as database.schema.table.

With Postgres, it is necessary to set up a FDW connection between every database where you want to perform a query and the database you want to query. In an analytics environment where a single server might have a hundred or so smaller databases, this is a grossly inefficient proposition.

Is it practical to provide the SQL Server-like feature in Postgres?
В списке pgsql-general по дате отправления
От: Basques, Bob (CI-StPaul)
Дата:
От: Tom Lane
Дата:
FAQ