public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Shivam Pandey <shivampandey91199@gmail.com>
To: pgsql-general@postgresql.org
Subject: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
Date: Sat, 16 May 2026 00:30:52 +0530
Message-ID: <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com> (raw)

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.

In PostgreSQL, achieving similar functionality often requires additional
setup using extensions such as postgres_fdw or dblink. While these
solutions are powerful and architecturally clean, they can feel complex for
developers who are building applications rapidly or migrating from systems
like MySQL.

It would be valuable if PostgreSQL could provide a more developer-friendly
and simplified native approach for cross-database querying while still
maintaining PostgreSQL’s strong isolation and security principles.

Possible improvements could include:

1)Simpler syntax for cross-database joins
2) Easier configuration for trusted local databases
3) Built-in lightweight federation support
4) Better onboarding documentation for multi-database use cases

PostgreSQL is already one of the most powerful and respected databases in
the industry. Enhancing developer convenience in this area could make
adoption even smoother for many teams.

Thank you for your incredible work and continuous innovation.

Best Regards,
Shivam Pandey

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: shivampandey91199@gmail.com
  Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
  In-Reply-To: <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox