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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Guyren Howe <guyren(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Can we get SQL Server-like cross database queries
Date: 2020-06-03 19:57:14
Message-ID: FDD6456F-89BF-432B-98AC-AA1BFAA20549@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jun 3, 2020, at 1:46 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Guyren Howe <guyren(at)gmail(dot)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 be up-close-and-personal with a db payroll?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2020-06-03 20:10:55 Re: pg_dump of database with numerous objects
Previous Message Tom Lane 2020-06-03 19:46:42 Re: Can we get SQL Server-like cross database queries