test_tblspace.sql

\timing off
select current_user;
show role;
show temp_tablespaces;
\db+ rn_temp_01
\echo create temporary table test1 (a int);
create temporary table test1 (a int);
\echo
\echo select relname,reltablespace from pg_class where relname = 'test1';
select relname,reltablespace from pg_class where relname = 'test1';
\echo drop role if exists test_role;
drop role if exists test_role;
\echo create role test_role;
create role test_role;
\echo set role test_role;
set role test_role;
\echo create temporary table test3 (a int);
create temporary table test3 (a int);