Postgres 13

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

CREATE TABLE my_table
(
    id           uuid GENERATED ALWAYS AS (md5('xx' ||  value)::uuid) STORED,
    code         VARCHAR(50) PRIMARY KEY,
    value        VARCHAR(50),
    last_updated TIMESTAMP WITH TIME ZONE DEFAULT now()
);


CREATE TABLE


INSERT INTO my_table (code, value)
VALUES ('a','a'), 
       ('b','b');

INSERT 0 2


SELECT * FROM my_table


id
code
value
last_updated


b03481e8-0c60-bbfc-a842-69bfd7a4df27
a
a
2024-05-19 17:02:51.846899+01

b2b46220-d545-35eb-548c-975f37cdf51b
b
b
2024-05-19 17:02:51.846899+01



SELECT 2

id	code	value	last_updated
b03481e8-0c60-bbfc-a842-69bfd7a4df27	a	a	2024-05-19 17:02:51.846899+01
b2b46220-d545-35eb-548c-975f37cdf51b	b	b	2024-05-19 17:02:51.846899+01