Postgres 11

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

CREATE TABLE test (
  prod_num VARCHAR(14),
  owner VARCHAR(255) default NULL,
  prod_date VARCHAR(255),
  pseudo_num VARCHAR(14)
);
INSERT INTO test (prod_num, owner, prod_date) VALUES
    ('260619275', 'Kieran', 'Feb 10, 2018'),
    ('316556232', 'Steven', 'Jan 6, 2020'),
    ('316556232', 'Steven', 'Jan 6, 2020'),
    ('625302534', 'Oliver', 'Feb 10, 2018'),
    ('811424845', 'Jeremy', 'Apr 12, 2018'),
    ('060961216', 'Quinlan', 'Jul 19, 2019'),
    ('713794360', 'Stuart', 'Nov 1, 2019'),
    ('553381666', 'George', 'Jan 8, 2019'),
    ('978519361', 'Macon', 'Nov 26, 2018'),
    ('352718969', 'Raphael', 'Jul 21, 2019'),
    ('803299478', 'Byron', 'Nov 26, 2019'),
    ('696124452', 'Dalton', 'Jul 17, 2018'),
    ('892088485', 'Keane', 'Jul 9, 2018'),
    ('817054190', 'Dillon', 'Apr 23, 2018'),
    ('500170097', 'Fitzgerald', 'Feb 11, 2019'),
    ('663252252', 'Thomas', 'Apr 10, 2018'),
    ('061983557', 'Alan', 'May 12, 2018'),
    ('492057435', 'Jarrod', 'Apr 16, 2018'),
    ('837802495', 'Shad', 'Mar 22, 2019'),
    ('725698187', 'Mark', 'Jul 22, 2018'),
    ('153352349', 'Akeem', 'Feb 19, 2018');
21 rows affected

SELECT prod_num, UPPER(RIGHT(MD5(prod_num), LENGTH(prod_num))) FROM test;


prod_num
upper


260619275
1AF1F80BB

316556232
CE09AEB6D

316556232
CE09AEB6D

625302534
C0D863D3A

811424845
B1A0CD1C6

060961216
EF81DF339

713794360
16D009C1D

553381666
128BA124D

978519361
62056B0A7

352718969
06B02E299

803299478
3544F390B

696124452
14D80C16E

892088485
773F470FD

817054190
1F2AE4F24

500170097
C96715C20

663252252
448997E24

061983557
5180A9EA4

492057435
F74592552

837802495
72A324BFB

725698187
2DCA2D79E

153352349
D1F333A6E


UPDATE test SET pseudo_num = UPPER(RIGHT(MD5(prod_num), LENGTH(prod_num)));
21 rows affected

SELECT * FROM test;


prod_num
owner
prod_date
pseudo_num


260619275
Kieran
Feb 10, 2018
1AF1F80BB

316556232
Steven
Jan 6, 2020
CE09AEB6D

316556232
Steven
Jan 6, 2020
CE09AEB6D

625302534
Oliver
Feb 10, 2018
C0D863D3A

811424845
Jeremy
Apr 12, 2018
B1A0CD1C6

060961216
Quinlan
Jul 19, 2019
EF81DF339

713794360
Stuart
Nov 1, 2019
16D009C1D

553381666
George
Jan 8, 2019
128BA124D

978519361
Macon
Nov 26, 2018
62056B0A7

352718969
Raphael
Jul 21, 2019
06B02E299

803299478
Byron
Nov 26, 2019
3544F390B

696124452
Dalton
Jul 17, 2018
14D80C16E

892088485
Keane
Jul 9, 2018
773F470FD

817054190
Dillon
Apr 23, 2018
1F2AE4F24

500170097
Fitzgerald
Feb 11, 2019
C96715C20

663252252
Thomas
Apr 10, 2018
448997E24

061983557
Alan
May 12, 2018
5180A9EA4

492057435
Jarrod
Apr 16, 2018
F74592552

837802495
Shad
Mar 22, 2019
72A324BFB

725698187
Mark
Jul 22, 2018
2DCA2D79E

153352349
Akeem
Feb 19, 2018
D1F333A6E

prod_num	upper
260619275	1AF1F80BB
316556232	CE09AEB6D
316556232	CE09AEB6D
625302534	C0D863D3A
811424845	B1A0CD1C6
060961216	EF81DF339
713794360	16D009C1D
553381666	128BA124D
978519361	62056B0A7
352718969	06B02E299
803299478	3544F390B
696124452	14D80C16E
892088485	773F470FD
817054190	1F2AE4F24
500170097	C96715C20
663252252	448997E24
061983557	5180A9EA4
492057435	F74592552
837802495	72A324BFB
725698187	2DCA2D79E
153352349	D1F333A6E

prod_num	owner	prod_date	pseudo_num
260619275	Kieran	Feb 10, 2018	1AF1F80BB
316556232	Steven	Jan 6, 2020	CE09AEB6D
316556232	Steven	Jan 6, 2020	CE09AEB6D
625302534	Oliver	Feb 10, 2018	C0D863D3A
811424845	Jeremy	Apr 12, 2018	B1A0CD1C6
060961216	Quinlan	Jul 19, 2019	EF81DF339
713794360	Stuart	Nov 1, 2019	16D009C1D
553381666	George	Jan 8, 2019	128BA124D
978519361	Macon	Nov 26, 2018	62056B0A7
352718969	Raphael	Jul 21, 2019	06B02E299
803299478	Byron	Nov 26, 2019	3544F390B
696124452	Dalton	Jul 17, 2018	14D80C16E
892088485	Keane	Jul 9, 2018	773F470FD
817054190	Dillon	Apr 23, 2018	1F2AE4F24
500170097	Fitzgerald	Feb 11, 2019	C96715C20
663252252	Thomas	Apr 10, 2018	448997E24
061983557	Alan	May 12, 2018	5180A9EA4
492057435	Jarrod	Apr 16, 2018	F74592552
837802495	Shad	Mar 22, 2019	72A324BFB
725698187	Mark	Jul 22, 2018	2DCA2D79E
153352349	Akeem	Feb 19, 2018	D1F333A6E