PostgreSQL random text function

random_text.sql

-- http://www.postgresql.org/message-id/[email protected]

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)), '-', ''));

Wow, cool!