MIME-Version: 1.0
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> <c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel@cybertec.at>
In-Reply-To: <c8c8dd9de6f6d34a0bf73ed67fa04dd4b0371826.camel@cybertec.at>
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, 29 Jul 2025 10:27:05 -0400
Message-ID: <CA+FnnTx+PUY8kJYNXnp3itLrSML3QZ5DtRssDVbAXQZsecrf=Q@mail.gmail.com>
Subject: Re: Get info about the index
To: Laurenz Albe <laurenz.albe@cybertec.at>
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>
Content-Type: multipart/alternative; boundary="0000000000008fb9da063b12345f"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTx%2BPUY8kJYNXnp3itLrSML3QZ5DtRssDVbAXQZsecrf%3DQ%40mail.gmail.com>
Precedence: bulk

--0000000000008fb9da063b12345f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 29, 2025, 9:24=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec.a=
t> 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
>

--0000000000008fb9da063b12345f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jul 29, 2025, 9:24=E2=80=
=AFAM Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.=
albe@cybertec.at</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On =
Tue, 2025-07-29 at 07:18 -0500, Igor Korot wrote:<br>
&gt; If I have a database for some financial data for the year 2024 in the<=
br>
&gt; mydb_2024 and I have current year financial data in the mydb_2025 how<=
br>
&gt; can I compare the data?<br>
<br>
You connect to both and query them both.<br>
<br>
Alternatively, you use postgres_fdw to access the other database.<br>
<br>
Even better, put both tables in the same database, perhaps in different sch=
emas.<br></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"a=
uto">Understood.</div><div dir=3D"auto"><br></div><div dir=3D"auto">It was =
just an educational question to better understand all possible ways to proc=
eed.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thank you.</div><di=
v dir=3D"auto"><br></div><div dir=3D"auto"><div class=3D"gmail_quote gmail_=
quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div></div>

--0000000000008fb9da063b12345f--