SQL

select indexes postgres

SELECT
    tablename,
    indexname,
    indexdef
FROM
    pg_indexes;

select indexname psql

SELECT
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    tablename = 'table_name';
Code language: JavaScript (javascript)