returns text as $body$ select upper (array_to_string( array ( select substring ( '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz' FROM ( ceil (random() * 62 )):: int FOR 1 ) FROM generate_series( 1 , $ 1 )), '' )); $body$ language sql volatile; 复制代码

sample:

select random_string(32);
复制代码

生成32位随机数然后大写。

QWMWQHSVYVF71ZDPZHT2RLP47NGBQYYQ 复制代码