CREATE OR REPLACe FUNCTION intpkmax() RETURNS TABLE(schema_name name, table_name name, column_name name, max_value integer) LANGUAGE plpgsql STABLE AS$$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 LOOP EXECUTE 'SELECT max(' || quote_ident(column_name) || ') FROM ' || quote_ident(schema_name) || '.' || quote_ident(table_name) || '' INTO max_value; RETURN NEXT; END LOOP;END;$$;然后你可以得到一个清单
SELECt * FROM intpkmax();
