index istenen schemadaki index adlari ve tablespace degistirme
Definition Description
SELECT * FROM pg_indexes WHERE schemaname = 'EDI'
veya
SELECT 'ALTER INDEX '||indexrelid::regclass||' SET TABLESPACE "ERPIDXSPC"; ' FROM pg_stat_user_indexes JOIN pg_index USING ( indexrelid ) WHERE schemaname='ERP' ORDER BY indexrelid::regclass ;
