| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | David Barbour <david(dot)barbour(at)amiralearning(dot)com>, Jon Zeppieri <zeppieri(at)gmail(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Get info about the index |
| Date: | 2025-07-29 13:24:02 |
| Message-ID: | c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2025-07-29 14:27:05 | Re: Get info about the index |
| Previous Message | Igor Korot | 2025-07-29 12:18:15 | Re: Get info about the index |