PG Index

Started by akp geekover 16 years ago2 messagesgeneral
Jump to latest
#1akp geek
akpgeek@gmail.com

Hi All -

Is there way to the list of indexes created for all the tables in
postgres? can you please help

Regards
Venkat

#2Chris Ernst
cernst@esoft.com
In reply to: akp geek (#1)
Re: PG Index

SELECT * from pg_stat_user_indexes;

Show quoted text

On 01/07/2010 02:23 PM, akp geek wrote:

Hi All -

Is there way to the list of indexes created for all the tables
in postgres? can you please help

Regards
Venkat