On Wednesday, June 3, 2020, Laurenz Albe wrote:
> On Thu, 2020-06-04 at 16:41 +1200, Thomas Munro wrote:
> > There's no doubt it's useful, and it's also part of the SQL spec,
> > which says you can do catalog.schema.table. I would guess that we
> > might get that as a byproduct of any project to
On Thu, Jun 4, 2020 at 12:56 AM Laurenz Albe
wrote:
> On Thu, 2020-06-04 at 16:41 +1200, Thomas Munro wrote:
> > There's no doubt it's useful, and it's also part of the SQL spec,
> > which says you can do catalog.schema.table. I would guess that we
> > might get that as a byproduct of any projec
On Thu, 2020-06-04 at 16:41 +1200, Thomas Munro wrote:
> There's no doubt it's useful, and it's also part of the SQL spec,
> which says you can do catalog.schema.table. I would guess that we
> might get that as a byproduct of any project to make PostgreSQL
> multithreaded. That mountain moving op
On Thu, Jun 4, 2020 at 4:26 PM Ron wrote:
> On 6/3/20 2:57 PM, Rob Sargent wrote:
> >> On Jun 3, 2020, at 1:46 PM, Tom Lane wrote:
> >> Guyren Howe writes:
> >>> Is it practical to provide the SQL Server-like feature in Postgres?
> >> No.
> > That got me chuckling.
> > I had just decided not to
On 6/3/20 2:57 PM, Rob Sargent wrote:
On Jun 3, 2020, at 1:46 PM, Tom Lane wrote:
Guyren Howe 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 wel
> On Jun 3, 2020, at 1:46 PM, Tom Lane wrote:
>
> Guyren Howe 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 cal
Guyren Howe writes:
> Is it practical to provide the SQL Server-like feature in Postgres?
No.
regards, tom lane
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
d