drop_create_indexes.sql

SELECT
  'DROP INDEX "'||nspname||'"."'||relname||'" RESTRICT;'
FROM pg_index
INNER JOIN pg_class ON indexrelid=pg_class.oid
INNER JOIN pg_namespace ON pg_namespace.oid=pg_class.relnamespace
WHERE indrelid = (SELECT oid FROM pg_class WHERE relname='??')
AND indisprimary=FALSE
AND indisvalid=TRUE
AND nspname NOT LIKE 'pg_%25'
ORDER BY nspname,relname;

SET search_path=public;
SELECT pg_get_indexdef(pg_index.indexrelid)||';' FROM pg_index
INNER JOIN pg_class ON indexrelid=pg_class.oid
INNER JOIN pg_namespace ON pg_namespace.oid=pg_class.relnamespace
WHERE indrelid = (SELECT oid FROM pg_class WHERE relname='??')
AND indisprimary=FALSE
AND indisvalid=TRUE
AND nspname NOT LIKE 'pg_%25'
ORDER BY nspname,relname;