Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Shivam Pandey <shivampandey91199(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
Date: 2026-05-16 02:15:25
Message-ID: CAMsGm5dN45keV8KsY5HJ5j6pOHMGwjS-Udasd6LJ7iq_mP1rnw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 15 May 2026 at 18:06, Shivam Pandey <shivampandey91199(at)gmail(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-05-16 06:40:32 Double prepare
Previous Message Ron Johnson 2026-05-15 23:57:45 Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL