Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

CREATE TABLE foo (
    id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    name TEXT DEFAULT md5(random()::text)
);

CREATE TABLE

insert into foo (id)
  OVERRIDING USER VALUE
select null
from generate_series(1, 10) as gs(i) ;

INSERT 0 10

select * from foo ;

id
name

1
13ed78d695c98ba420d750adf3c0fbd5

2
345a0494c374781e25cda27ff4e1feb3

3
c3e718974a8608141fbeb81883cdecc6

4
fe29a634957936723965d3a3cabf888c

5
2387456c7a9c46c9ab729f98c9d91ee2

6
df88b9564baf8e514737d3b78efa15ec

7
5a0c6d677962d1a2edc3737a004afe9d

8
c26137cec12d7e5b5593093be6ffc823

9
42b675c6503956f469db9eb5dcd92577

10
d9401a01a5d88201a68902946bb4a385

SELECT 10

id	name
1	13ed78d695c98ba420d750adf3c0fbd5
2	345a0494c374781e25cda27ff4e1feb3
3	c3e718974a8608141fbeb81883cdecc6
4	fe29a634957936723965d3a3cabf888c
5	2387456c7a9c46c9ab729f98c9d91ee2
6	df88b9564baf8e514737d3b78efa15ec
7	5a0c6d677962d1a2edc3737a004afe9d
8	c26137cec12d7e5b5593093be6ffc823
9	42b675c6503956f469db9eb5dcd92577
10	d9401a01a5d88201a68902946bb4a385