Cross DB query - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Cross DB query
Date
Msg-id CAB-JLwYOYRKAiZZg8JMCLsG1GZzQ_L3gHMaMrV1Bi2hZz1V9eQ@mail.gmail.com
Whole thread Raw
Responses Re: Cross DB query
List pgsql-hackers
A question I always have, and I didn´t find anybody answering it. If it´s possible 
select * from MyDB.MySchema.MyTable;

And from user point of view ... all databases are accessible for the same postgres instance, user just says connect to this or that database, why is it not possible to do
select * from FirstDB.FirstSchema.FirstTable join SecondDB.SecondSchema. SecondTable;

Everything I found was how to connect, using FDW or DBLink, but not why.

regards,
Marcos

pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: Appetite for Frama-C annotations?
Next
From: John Naylor
Date:
Subject: Re: speed up verifying UTF-8