vztsjLC2yZnC6yvbvtvg
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
intpkmax()
Parameters
Name
Type
Mode
schema_name
name
OUT
table_name
name
OUT
column_name
name
OUT
max_value
integer
OUT
Definition
BEGIN FOR schema_name, table_name, column_name IN SELECT sch.nspname, tab.relname, col.attname FROM pg_class tab JOIN pg_constraint con ON con.conrelid = tab.oid JOIN pg_attribute col ON col.attrelid = tab.oid JOIN pg_namespace sch ON sch.oid = tab.relnamespace WHERE con.contype = 'p' AND array_length(con.conkey, 1) = 1 AND col.atttypid = 'integer'::regtype AND NOT col.attisdropped AND sch.nspname = 'public' AND col.attname = 'id' LOOP EXECUTE 'SELECT max(' || quote_ident(column_name) || ') FROM ' || quote_ident(schema_name) || '.' || quote_ident(table_name) || '' INTO max_value; /* return the next result */ RETURN NEXT; END LOOP; END;