[PostgreSQL] postgresql 인덱스 엔티티명,테이블,인덱스이름 조회

SELECT OBJ_DESCRIPTION(TABLE_NAME::regclass, 'pg_class')    AS TABLE_COMMENTS,

            upper(table_name) as table_name,

            upper(constraint_name) as constraint_name

       from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

                                       where CONSTRAINT_TYPE = 'PRIMARY KEY'

        AND constraint_schema  = 'naqsifh'

     order by 1