Get table catalog from pg_indexes

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Get table catalog from pg_indexes
Date: 2022-11-27 17:22:50
Message-ID: CA+FnnTxHT4K+oRrVytEDVMmG1nLcH9zkMb-_wx-FyKJOJ__zTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
Table pg_indexes does not contain a field for a catalog.

So how do I get that?

SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
schemaname = $3

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2022-11-27 17:59:35 Re: Get table catalog from pg_indexes
Previous Message William Torrez Corea 2022-11-27 02:52:02 Re: collect2: error: ld returned 1 exit status