DO $$
DECLARE
  index_name text;
BEGIN
  SELECT indexname from pg_indexes WHERE tablename = 'dsm_user' AND indexname like '%_pkey%' INTO index_name;
  IF index_name != 'dsm_user_pkey' THEN
    EXECUTE 'ALTER INDEX ' || index_name || ' RENAME TO dsm_user_pkey';
  END IF;
  SELECT indexname from pg_indexes WHERE tablename = 'dsm_user' AND indexname like '%_name_idx%' INTO index_name;
  IF index_name != 'dsm_user_name_idx' THEN
    EXECUTE 'ALTER INDEX ' || index_name || ' RENAME TO dsm_user_name_idx';
  END IF;
  SELECT indexname from pg_indexes WHERE tablename = 'dsm_group' AND indexname like '%_pkey%' INTO index_name;
  IF index_name != 'dsm_group_pkey' THEN
    EXECUTE 'ALTER INDEX ' || index_name || ' RENAME TO dsm_group_pkey';
  END IF;
  SELECT indexname from pg_indexes WHERE tablename = 'dsm_group' AND indexname like '%_name_idx%' INTO index_name;
  IF index_name != 'dsm_group_name_idx' THEN
    EXECUTE 'ALTER INDEX ' || index_name || ' RENAME TO dsm_group_name_idx';
  END IF;
END $$;