postgreSQL: generate big data of unique numbers

Sources:

• How to generate random unique number in PostgreSQL using function
• How can I generate big data sample for Postgresql using generate_series and random?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

CREATE OR REPLACE FUNCTION jerome_pseudo_encrypt(VALUE int) returns int AS $$ DECLARE l1 int; l2 int; r1 int; r2 int; i int:=0; BEGIN  l1:= (VALUE >> 16) & 65535;  r1:= VALUE & 65535;  WHILE i < 3 LOOP    l2 := r1;    r2 := l1 # ((((1366 * r1 + 150889) % 714025) / 714025.0) * 32767)::int;    l1 := l2;    r1 := r2;    i := i + 1;  END LOOP;  RETURN ((r1 << 16) + l1); END; $$ LANGUAGE plpgsql strict immutable;

1 2 3

create sequence jerome_seq maxvalue 2147483647; create table prov_db.dt_hpe_dev (hpe_dev_id bigserial, sim_id bigint, constraint dt_hpe_dev_pkey primary key (hpe_dev_id)); insert into prov_db.dt_hpe_dev (sim_id) select jerome_pseudo_encrypt(nextval('jerome_seq')::int)  from generate_series(1, 1000000);