How to restart the function if the result is missing a large or small letter, number, symbol?

Question

PostgreSQL

There is a key generation code, but sometimes an error pops up if there is not enough character, etc.

SELECT string_agg(substring('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!#$%&()*+,-./:;<=>[email protected][]^', ceil(random() * 85)::integer, 1), '') FROM generate_series(1,32);

Answer 1

Don't worry, take a ready-made extension for PostgreSQL:

create extension if not exists pgcrypto;
select encode(gen_random_bytes(32),'base64');

Test PostgreSQL query