do
$$
declare
_rec record;
_exists boolean;
_sql text;
begin
 for _rec in (select table_schema, table_name from information_schema.tables)
   loop
      _exists := false;
      _sql := format('select exists(select null from %s.%s limit 1)',_rec.table_schema, _rec.table_name);
      execute _sql into _exists;
      if _exists then 
        raise notice '%.%', _rec.table_schema, _rec.table_name;
      end if;
   end loop;
end;
$$language plpgsql;