On Tue, Jul 29, 2025, 9:24 AM Laurenz Albe <laurenz.a...@cybertec.at> 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 >
