修改了一下，将原输出字符中做为分隔符的‘a'（会重复出现多次）去除。 CREATE FUNCTION random_str(length integer) RETURNS character varying LANGUAGE plpgsql IMMUTABLE NOT SHIPPABLE AS $_$ DECLARE result varchar; BEGIN select regexp_replace(array_to_string(array(select substring('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz' FROM (ceil(random()*62))::int FOR 1) FROM generate_series(1, $1)),'#','#'),'#','') INTO result; return result; end $_$;