Re: Can we get SQL Server-like cross database queries - Mailing list pgsql-general

From Rob Sargent
Subject Re: Can we get SQL Server-like cross database queries
Date
Msg-id FDD6456F-89BF-432B-98AC-AA1BFAA20549@gmail.com
Whole thread Raw
In response to Re: Can we get SQL Server-like cross database queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Can we get SQL Server-like cross database queries  (Ron <ronljohnsonjr@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can we get SQL Server-like cross database queries
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump of database with numerous objects