问postgresql使用通配符截断级联表

EN

do $$

  declare
    tr pg_tables%rowtype;
  begin
    for tr in
      select * from pg_tables WHERE tableowner = 'XXX';
    loop
      execute format('TRUNCATE TABLE %I.%I CASCADE;', tr.schemaname, tr.tablename);
    end loop;
  end;

$$;

do $$
  declare
    names text;
    my_sql text;
  begin
    select string_agg(format('%I.%I', schemaname, tablename), ', ')
      into names
      from pg_tables 
      where tableowner = 'XXX';
    if names<>'' then
      my_sql = 'TRUNCATE TABLE '||names||' CASCADE';
      execute my_sql;
    end if;
  end;
$$;