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
