From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(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 22:11:42 |
Message-ID: | CA+FnnTyYbNfbnekXGP=tpuFWpw_bFX7-xDVasyWFcsoSHZeDMw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
David,
On Sun, Nov 27, 2022 at 12:55 PM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> 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.
Yes, I am and I get that.
>
> 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.
Apparently it looks like this query fails to execute.
I am connected to the "draft" database and running
SELECT 1 FROM draft.pg_indexes;
gives:
[quote]
ERROR:schema "draft" does not exist
[/quote]
Thank you/
>
> David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2022-11-27 22:13:23 | Re: Get table catalog from pg_indexes |
Previous Message | Ron | 2022-11-27 22:10:19 | Re: Get table catalog from pg_indexes |