Re: Can we get SQL Server-like cross database queries

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Can we get SQL Server-like cross database queries
Дата
Msg-id FDD6456F-89BF-432B-98AC-AA1BFAA20549@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  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general

> On Jun 3, 2020, at 1:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Guyren Howe <guyren@gmail.com> writes:
>> Is it practical to provide the SQL Server-like feature in Postgres?
>
> No.
>
>             regards, tom lane
>
>
That got me chuckling.
I had just decided not to bother posting, but well, here goes.

I call bs on the “cross db query” notion of tsql - but I admit I haven’t used it since it was a Sybase thing.

Is db.owner.table (iirc) is really anything more than nuance on schema.table.  Does a db for automotive parts need to
beup-close-and-personal with a db payroll? 









В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can we get SQL Server-like cross database queries
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump of database with numerous objects