Postgres: Display Indexes and Constraints for a specific Table

pg_constraints.sql

SELECT
  nsp.nspname
  , rel.relname
  , con.*
FROM
  pg_catalog.pg_constraint con
  INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid
  INNER JOIN pg_catalog.pg_namespace nsp ON nsp.oid = connamespace
WHERE
  nsp.nspname = '<schema name>'
  AND
  rel.relname = '<table name>'
ORDER BY 1,2
;

pg_enums.sql

SELECT 
  n.nspname AS enum_schema
  , t.typname AS enum_name
  , e.enumlabel AS enum_value
FROM 
  pg_type t 
  JOIN pg_enum e ON t.oid = e.enumtypid  
  JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
WHERE
  n.nspname = '<schema name>'
ORDER BY 1,2,3
;

pg_indexes.sql

SELECT *
FROM pg_indexes
WHERE 
  schemaname = '<schema name>'
  AND
  tablename = '<table name>'
;