Definitions More Info.
Definition ID	859
Title	POSTGRESQL
Category	NOTES
Definition	change table space for INDEX
Definition Description	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 ;
RecordBy	cunay
Record Date	25-07-2018 10:28:48
Düzenle
Kopyala
Sil