PostgreSQL random text function

random_text.sql

-- http://www.postgresql.org/message-id/bddc86150908200534p14723ac2vd1ef223af095d822@mail.gmail.com

CREATE OR REPLACE FUNCTION
random_text(INTEGER)
RETURNS TEXT
LANGUAGE SQL
AS $$
SELECT array_to_string(array(
  SELECT SUBSTRING('23456789abcdefghjkmnpqrstuvwxyz' 
    FROM floor(random()*31)::int+1 FOR 1)
  FROM generate_series(1, $1)), '');
$$;

-- use UUID, only returns hex
SELECT lower(replace(cast(uuid_generate_v4() as varchar(50)), '-', ''));

Great routine. The avoidance of similar looking digits was a nice touch.

Wow, cool!