make_all_rows_visible_in_schema(scm character varying)

DECLARE

  myrec RECORD;

  stmt VARCHAR;

  query VARCHAR;

  bt_schema VARCHAR;

BEGIN

  bt_schema = scm || '_bt';

  query = 'SELECT relname 

             FROM pg_class c, pg_namespace n

            WHERE c.relnamespace=n.oid 

              AND c.relkind=''r''

              AND n.nspname=''' || bt_schema || '''';

--  RAISE NOTICE '%', query; --stmt;

  FOR myrec IN EXECUTE query LOOP

    RAISE NOTICE 'Making rows in ''%'' visible', myrec.relname;

    stmt = 'SELECT make_all_rows_visible(''' || scm || '''::varchar, ''' || myrec.relname || '''::varchar)';

    --RAISE NOTICE '%', stmt;

    EXECUTE stmt;

  END LOOP;

  RETURN 't';

END