union all tables in a schema

schema_union.sql

DO 
$$
declare
 vv text;
 hh record;
 qry text;
 qar text[];
 begin
 qry = 'create table plus1.plus1 as ';
for hh in select * from pg_tables where schemaname = 'plus1' loop
  qar = array_append(qar, ' SELECT "Name", description, geom from plus1.'|| quote_ident(hh.tablename));
  
end loop;
raise notice '%', qry ||array_to_string(qar, e'\n UNION \n'::text);

end;
$$ language plpgsql