Search Postgresql Archives

Re: Get info about the index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Get info about the index
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Tue, 29 Jul 2025 15:24:02 +0200
Cc: David Barbour <david.barbour@xxxxxxxxxxxxxxxxx>, Jon Zeppieri <zeppieri@xxxxxxxxx>, Christophe Pettus <xof@xxxxxxxxxxxx>, Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
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>
User-agent: Evolution 3.56.2 (3.56.2-1.fc42)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Get info about the index
  - From: Igor Korot

References:
- Get info about the index
  - From: Igor Korot
- Re: Get info about the index
  - From: Adrian Klaver
- Re: Get info about the index
  - From: Igor Korot
- Re: Get info about the index
  - From: Christophe Pettus
- Re: Get info about the index
  - From: Igor Korot
- Re: Get info about the index
  - From: Jon Zeppieri
- Re: Get info about the index
  - From: David Barbour
- Re: Get info about the index
  - From: Laurenz Albe
- Re: Get info about the index
  - From: Igor Korot
- Re: Get info about the index
  - From: Laurenz Albe
- Re: Get info about the index
  - From: Igor Korot

Prev by Date: Re: Get info about the index
Next by Date: Re: Get info about the index
Previous by thread: Re: Get info about the index
Next by thread: Re: Get info about the index
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]