Re: [GENERAL] How to know the indexes on a Table

Hi all, Is there any way, to know the name of indexes on a table, defined in a database. I mean can I query something like Select Index_name from pg_class where relname = "Table_name" . Thanks in advance. --- Thanks & Reagrds Anirban Pal | Software Engineer Newgen Software Tech

Re: [GENERAL] How to know the indexes on a Table

"Anirban Pal" writes: > Is there any way, to know the name of indexes on a table, defined in a > database. I mean can I query something like > Select Index_name from pg_class where relname = "Table_name" . Thanks in > advance. You need to join through pg_index, specifically its columns indrel

[GENERAL] How to know the indexes on a Table

Hi all, Is there any way, to know the name of indexes on a table, defined in a database. I mean can I query something like Select Index_name from pg_class where relname = "Table_name" . Thanks in advance. --- Thanks & Reagrds Anirban Pal | Software Engineer Newgen Software Technolo