quick postgres SQL for replacing an index

replace-index.sql

-- get existing index names and SQL definitions
SELECT indexname, indexdef
FROM pg_indexes
WHERE schemaname = 'public' AND tablename = 'table'
ORDER BY indexname;

-- create new tmp index (example)
CREATE INDEX tmp_name_of_the_index ON public.table USING btree (time ASC);
-- drop existing index
DROP INDEX name_of_the_index;
-- mv the tmp index to the previous name
ALTER INDEX tmp_name_of_the_index RENAME TO name_of_the_index;