maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_getsequencelastval()
Parameters
Name
Type
Mode
seqname
character varying
OUT
last_value
bigint
OUT
Definition
DECLARE _seqname varchar; BEGIN FOR _seqname IN (SELECT c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('S','') AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema' AND n.nspname !~ '^pg_toast' AND pg_catalog.pg_table_is_visible(c.oid) AND n.nspname = 'public' ORDER BY 1) LOOP EXECUTE format ('SELECT last_value FROM %I',_seqname) INTO last_value; SELECT _seqname INTO seqname; RETURN NEXT; END LOOP; END;