Create a PostgreSQL function that generates a random a Base32 string. Note that it might not be compatible with 8-bit ASCII under certain length because it maps each 5 bits to one Base32 character, so multiples of 8 will work. (8 5-bit Base32 characters = 40-bit = 5 8-bit ASCII characters) (Adapted from : http://stackoverflow.com/questions/39707…

randomBase32.sql

CREATE OR REPLACE FUNCTION yourschema.randomBase32(length integer) 
RETURNS text AS $$
declare
  chars text[] := '{2,3,4,5,6,7,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z}';
  result text := '';
  i integer := 0;
begin
  if length < 0 then
    raise exception 'Given length cannot be less than 0';
  end if;
  for i in 1..length loop
    result := result || chars[1+random()*(array_length(chars, 1)-1)];
  end loop;
  return result;
  end;
$$
LANGUAGE 'plpgsql' STABLE

Example usage

yourdb=# SELECT yourschema.randombase32(8);
 randombase32 
--------------
 G5XUN35G
(1 row)

This function should be marked VOLATILE rather than STABLE, see e.g. here