Get table catalog from pg_indexes

Igor Korot <ikorot01@gmail.com>

From: Igor Korot <ikorot01@gmail.com>

To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>

Date: 2022-11-27T17:22:50Z

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.