dbtest# \t
dbtest# \o dbtest_tablespace.txt
dbtest# select 'alter table '||tablename||' set tablespace temporary_tablespace;' from pg_tables where tablename like 'example%';
dbtest# select 'alter index '||indexname||' set tablespace temporary_tablespace;' from pg_indexes where tablename like 'example%';
dbtest# \i dbtest_tablespace.txt
