[postgres] delete a table's indexes function.

rm_table_idx.sql

CREATE OR REPLACE FUNCTION rm_table_idx(tbl_name text)
RETURNS void AS

$$
DECLARE
   _sql text;
BEGIN
   SELECT 'DROP INDEX ' || string_agg(indexrelid::regclass::text, ', ')
   FROM   pg_index  i
   LEFT   JOIN pg_depend d ON d.objid = i.indexrelid
                          AND d.deptype = 'i'
   WHERE  i.indrelid = tbl_name::regclass  -- possibly schema-qualified
   AND    d.objid IS NULL                      -- no internal dependency
   INTO   _sql;

   IF _sql IS NOT NULL THEN                    -- only if index(es) found
     raise notice '%', _sql;
     EXECUTE _sql;
   END IF;
END;
$$

LANGUAGE plpgsql;

Usage

select rm_table_idx('public.table_name1');