| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Get table catalog from pg_indexes |
| Date: | 2022-11-27 18:54:47 |
| Message-ID: | CAKFQuwaO3gauZGVpkAipq59bX0MvpAXRx-ts-iOd7R_+2jV9tg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Nov 27, 2022 at 11:42 AM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> It doesn't say anything about "current" DB - only the DB.
>
Yes, but you must be connected to some database in order to execute this
command: "the database" refers to this database you are connected to.
The catalogs are not information_schema.
> However, I think I can try "SELECT 1 FROM <catalog>.pg_indexes...".
> Will this work?
>
>
What is that even supposed to mean? It also seems simple enough to just do
that asking "will this work" is a waste of time. Just try it.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2022-11-27 18:55:16 | Re: Get table catalog from pg_indexes |
| Previous Message | Igor Korot | 2022-11-27 18:53:18 | Re: Get table catalog from pg_indexes |