public inbox for [email protected]
help / color / mirror / Atom feedRe: Get info about the index
2+ messages / 2 participants
[nested] [flat]
* Re: Get info about the index
@ 2025-07-29 13:24 Laurenz Albe <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Laurenz Albe @ 2025-07-29 13:24 UTC (permalink / raw)
To: Igor Korot <[email protected]>; +Cc: David Barbour <[email protected]>; Jon Zeppieri <[email protected]>; Christophe Pettus <[email protected]>; Adrian Klaver <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
On Tue, 2025-07-29 at 07:18 -0500, Igor Korot wrote:
> If I have a database for some financial data for the year 2024 in the
> mydb_2024 and I have current year financial data in the mydb_2025 how
> can I compare the data?
You connect to both and query them both.
Alternatively, you use postgres_fdw to access the other database.
Even better, put both tables in the same database, perhaps in different schemas.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Get info about the index
@ 2025-07-29 14:27 Igor Korot <[email protected]>
parent: Laurenz Albe <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Igor Korot @ 2025-07-29 14:27 UTC (permalink / raw)
To: Laurenz Albe <[email protected]>; +Cc: David Barbour <[email protected]>; Jon Zeppieri <[email protected]>; Christophe Pettus <[email protected]>; Adrian Klaver <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
On Tue, Jul 29, 2025, 9:24 AM Laurenz Albe <[email protected]> wrote:
> On Tue, 2025-07-29 at 07:18 -0500, Igor Korot wrote:
> > If I have a database for some financial data for the year 2024 in the
> > mydb_2024 and I have current year financial data in the mydb_2025 how
> > can I compare the data?
>
> You connect to both and query them both.
>
> Alternatively, you use postgres_fdw to access the other database.
>
> Even better, put both tables in the same database, perhaps in different
> schemas.
>
Understood.
It was just an educational question to better understand all possible ways
to proceed.
Thank you.
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-07-29 14:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-29 13:24 Re: Get info about the index Laurenz Albe <[email protected]>
2025-07-29 14:27 ` Igor Korot <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox