MIME-Version: 1.0
References: 
 <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com>
In-Reply-To: 
 <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com>
From: Isaac Morland <isaac.morland@gmail.com>
Date: Fri, 15 May 2026 22:15:25 -0400
Message-ID: 
 <CAMsGm5dN45keV8KsY5HJ5j6pOHMGwjS-Udasd6LJ7iq_mP1rnw@mail.gmail.com>
Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
To: Shivam Pandey <shivampandey91199@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b0851e0651e5e728"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMsGm5dN45keV8KsY5HJ5j6pOHMGwjS-Udasd6LJ7iq_mP1rnw%40mail.gmail.com>
Precedence: bulk

--000000000000b0851e0651e5e728
Content-Type: text/plain; charset="UTF-8"

On Fri, 15 May 2026 at 18:06, Shivam Pandey <shivampandey91199@gmail.com>
wrote:

> Hello PostgreSQL Team,
>
> I would like to share feedback from a developer perspective regarding
> cross-database querying in PostgreSQL.
>
> One feature that many developers appreciate in MySQL is the ability to
> directly query and join tables across multiple databases within the same
> server instance. This approach becomes very useful in real-world situations
> where applications need to access shared or distributed data quickly and
> efficiently.
>

What MySQL calls databases PostgreSQL calls schemas, and PostgreSQL
certainly has the ability to query and join tables across schemas.

What MySQL might call an instance (a collection of MySQL databases)
PostgreSQL calls a database (a collection of PostgreSQL schemas). A single
PostgreSQL instance has the ability to host multiple databases (albeit
sharing a single set of roles and role relationships). Can MySQL query and
join across multiple instances?

--000000000000b0851e0651e5e728
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, 15 May 2026 at 18:06, Shivam Pand=
ey &lt;<a href=3D"mailto:shivampandey91199@gmail.com">shivampandey91199@gma=
il.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">He=
llo PostgreSQL Team,<div dir=3D"auto"><br></div><div dir=3D"auto">I would l=
ike to share feedback from a developer perspective regarding cross-database=
 querying in PostgreSQL.</div><div dir=3D"auto"><br></div><div dir=3D"auto"=
>One feature that many developers appreciate in MySQL is the ability to dir=
ectly query and join tables across multiple databases within the same serve=
r instance. This approach becomes very useful in real-world situations wher=
e applications need to access shared or distributed data quickly and effici=
ently.</div></div></blockquote><div><br></div><div>What MySQL calls databas=
es PostgreSQL calls schemas, and PostgreSQL certainly has the ability to qu=
ery and join tables across schemas.</div><div><br></div><div>What MySQL=C2=
=A0might call an instance (a collection of MySQL databases) PostgreSQL call=
s a database (a collection of PostgreSQL schemas). A single PostgreSQL inst=
ance has the ability to host multiple databases (albeit sharing a single se=
t of roles and role relationships). Can MySQL query and join across multipl=
e instances?</div></div></div>

--000000000000b0851e0651e5e728--