cxgn_breedbase
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
make_all_rows_visible_in_schema(scm character varying)
Parameters
Name
Type
Mode
scm
character varying
IN
Definition
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