Postgres Pro
Downloads
Home   >   mailing lists

Get table catalog from pg_indexes - Mailing list pgsql-general

From Igor Korot
Subject Get table catalog from pg_indexes
Date
Msg-id CA+FnnTxHT4K+oRrVytEDVMmG1nLcH9zkMb-_wx-FyKJOJ__zTQ@mail.gmail.com
Whole thread Raw
Responses Re: Get table catalog from pg_indexes
Re: Get table catalog from pg_indexes
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: William Torrez Corea
Date:
Subject: Re: collect2: error: ld returned 1 exit status
Next
From: Erik Wienhold
Date:
Subject: Re: Get table catalog from pg_indexes