Message-ID: <c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel@cybertec.at>
Subject: Re: Get info about the index
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Igor Korot <ikorot01@gmail.com>
Cc: David Barbour <david.barbour@amiralearning.com>, Jon Zeppieri
	 <zeppieri@gmail.com>, Christophe Pettus <xof@thebuild.com>, Adrian Klaver
	 <adrian.klaver@aklaver.com>, "pgsql-generallists.postgresql.org"
	 <pgsql-general@lists.postgresql.org>
Date: Tue, 29 Jul 2025 15:24:02 +0200
In-Reply-To: <CA+FnnTzGZwjg5jJRVwMX_TyRpW+bJZAyN3EFv7qFv56_RfbFjw@mail.gmail.com>
References: 
	<CA+FnnTw2ouEQKSKzQ_SNo8efWE8wEqjr9Ux-F-wbR+y=Pn6bGg@mail.gmail.com>
	 <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com>
	 <CA+FnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ@mail.gmail.com>
	 <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com>
	 <CA+FnnTy8bdXxFZBmFfm1oNMQLVxL-+UmkX8EecbLB0MehX8gFw@mail.gmail.com>
	 <CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com>
	 <CAEMHB2QQpfxjbqbyB6zy+TMv9zf42tavLuYUSxDXgyZEaq46Xg@mail.gmail.com>
	 <7281c379994ffc70cebb68423f5b8ba339d0d75f.camel@cybertec.at>
	 <CA+FnnTyFwR_Xk8pEhasG7GGWAzFk9e4tCBdX36G6H1-=uJxrfg@mail.gmail.com>
	 <2fad4427bff83bc73f9b4215e284a76343f046f2.camel@cybertec.at>
	 <CA+FnnTzGZwjg5jJRVwMX_TyRpW+bJZAyN3EFv7qFv56_RfbFjw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel%40cybertec.at>
Precedence: bulk

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 sch=
emas.

Yours,
Laurenz Albe