查询所有符合条件的表名：

（我这里的条件是所有以“tbl_”开头除过“tbl_user"的所有表名）

create or replace function query_all_table_name() returns setof varchar as 
$$
  declare
    select_result record;
  begin
  for select_result in
    select tablename from ux_tables where tablename like 'tbl_%' and tablename != 'tbl_user'
  loop
    return next select_result.tablename;
  end loop;
  return;
  end;
$$
language pluxsql volatile
cost 100 rows 1000;

删除所有符合条件的表的数据：

（我这里是删除上边查出的这些表的数据）

create or replace function clear_table_data() returns text as 
$$
  declare
    select_result record;
    table_name varchar;
  begin
    for select_result in
      select tablename from ux_tables where tablename like 'tbl_%' and tablename != 'tbl_user'
    loop
      table_name = select_result.tablename;
      execute 'delete from ' || table_name;
    end loop;
    return 'success';
  end;
$$
language pluxsql;