Alterar os locais do INDEX postgresql

select 'ALTER INDEX '||schemaname||'.'||indexname||' SET TABLESPACE fastspace ;'
from pg_catalog.pg_indexes
where schemaname <> 'pg_catalog'
order by tablename;