stereoscott · June 22, 2014 17:38 · masilver99 · Jun 6, 2019 · ilyakaznacheev · Jan 30, 2020
diff --git a/random_text.sql b/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)), '-', ''));
	-- 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)), '-', ''));