Try
Home   >   mailing lists

Re: Get info about the index - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Get info about the index
Date
Msg-id c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel@cybertec.at
Whole thread Raw
In response to Re: Get info about the index  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Get info about the index
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Get info about the index
Next
From: Igor Korot
Date:
Subject: Re: Get info about the index