MIME-Version: 1.0
From: Shivam Pandey <shivampandey91199@gmail.com>
Date: Sat, 16 May 2026 00:30:52 +0530
Message-ID: 
 <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com>
Subject: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ad6c730651dfd58c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHWFTRjCy3U30whQJBw8z5_8boq%3DV9MzbtHMh6HZVP3o-OaGxg%40mail.gmail.com>
Precedence: bulk

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

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=E2=80=99s 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

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

<div dir=3D"auto">Hello PostgreSQL Team,<div dir=3D"auto"><br></div><div di=
r=3D"auto">I would like to share feedback from a developer perspective rega=
rding cross-database querying in PostgreSQL.</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">One feature that many developers appreciate in MySQL i=
s the ability to directly query and join tables across multiple databases w=
ithin the same server instance. This approach becomes very useful in real-w=
orld situations where applications need to access shared or distributed dat=
a quickly and efficiently.</div><div dir=3D"auto"><br></div><div dir=3D"aut=
o">In PostgreSQL, achieving similar functionality often requires additional=
 setup using extensions such as postgres_fdw or dblink. While these solutio=
ns are powerful and architecturally clean, they can feel complex for develo=
pers who are building applications rapidly or migrating from systems like M=
ySQL.</div><div dir=3D"auto"><br></div><div dir=3D"auto">It would be valuab=
le if PostgreSQL could provide a more developer-friendly and simplified nat=
ive approach for cross-database querying while still maintaining PostgreSQL=
=E2=80=99s strong isolation and security principles.</div><div dir=3D"auto"=
><br></div><div dir=3D"auto">Possible improvements could include:</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">1)Simpler syntax for cross-databa=
se joins</div><div dir=3D"auto">2) Easier configuration for trusted local d=
atabases</div><div dir=3D"auto">3) Built-in lightweight federation support<=
/div><div dir=3D"auto">4) Better onboarding documentation for multi-databas=
e use cases</div><div dir=3D"auto"><br></div><div dir=3D"auto">PostgreSQL i=
s already one of the most powerful and respected databases in the industry.=
 Enhancing developer convenience in this area could make adoption even smoo=
ther for many teams.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Tha=
nk you for your incredible work and continuous innovation.</div><div dir=3D=
"auto"><br></div><div dir=3D"auto">Best Regards,</div><div dir=3D"auto">Shi=
vam Pandey=C2=A0</div></div>

--000000000000ad6c730651dfd58c--