random

pig build pkg pg_random;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_random;		# install via package name, for the active PG version
pig install random;		# install by extension name, for the current active PG version

pig install random -v 18;   # install for PG 18
pig install random -v 17;   # install for PG 17
pig install random -v 16;   # install for PG 16
pig install random -v 15;   # install for PG 15
pig install random -v 14;   # install for PG 14

CREATE EXTENSION random;

CREATE EXTENSION random;

-- Generate reproducible random integers
SELECT random_int(42, 100, 1, 1000) FROM generate_series(1, 10);

-- Random strings of length 5-10
SELECT random_string(42, 1000, 5, 10) FROM generate_series(1, 5);

-- Random IP addresses
SELECT random_inet(42, 256) FROM generate_series(1, 5);