PostgreSQL Set some tables to unlogged mode

gistfile1.txt

do

$$
declare var_sql character varying(8000);
begin
	for var_sql in  
   
     select 
        
          'alter table '|| t1.table_schema||'."'||t1.table_name||'" set unlogged'
      from
          INFORMATION_SCHEMA.tables t1
          join
		pg_namespace sch on (
			sch.nspname = t1.table_schema
		)
		
          join
		pg_class t2 on
		(
			t2.relname = t1.table_name
			and
			t2.relnamespace = sch.oid
		)
	  join
              information_schema.schemata sc ON(
              sc.catalog_name = t1.table_catalog
              and
              sc.schema_name = t1.table_schema
          )
      where 
          t1.table_type like 'BASE TABLE'
          and
          sc.schema_owner <>'postgres'
          and
          t1.table_schema = 'TEMP'
          AND
          relpersistence <> 'u'
		

	loop
		raise notice ' %',var_sql;
		execute var_sql;
	end loop;
end;
$$
language plpgsql;