| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| 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 14:27:05 |
| Message-ID: | CA+FnnTx+PUY8kJYNXnp3itLrSML3QZ5DtRssDVbAXQZsecrf=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 29, 2025, 9:24 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-07-29 15:35:52 | Re: Regarding logical replication issues with PostgreSQL versions 16and above |
| Previous Message | Laurenz Albe | 2025-07-29 13:24:02 | Re: Get info about the index |