Postgresql regex replace numbers to asterisks [duplicate]

Question

I use Postgresql and need to replace numbers to asterisk at database layer. Howerver I'm new to learn regex and seems to be hard to do this with my current knowledge.

I will have in my database 16 numbers varchar and I need to replace middle numbers with asterisk.

Example. 123467812345678 -> 12**********5678

Could someone tell me how regex for this should look like in postgresql ? Thanks in advance

(?<=..).(?=....)

Wiktor Stribiżew
– Wiktor Stribiżew

2022-09-19 14:40:28 +00:00
Commented Sep 19, 2022 at 14:40 — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Sep 19, 2022 at 14:40
see also regex101.com

jhole
– jhole

2022-09-19 14:41:07 +00:00
Commented Sep 19, 2022 at 14:41 — jhole
– jhole, Commented Sep 19, 2022 at 14:41

Frank Heikens · Accepted Answer · 2022-09-19 14:42:41Z

0

Thanks to @Wiktor Stribiżew:

SELECT regexp_replace('123467812345678', '(?<=..).(?=....)', '*','g');

answered Sep 19, 2022 at 14:42

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

javax Over a year ago

Thanks Wiktor and Frank. It solves my problem

Collectives™ on Stack Overflow

Postgresql regex replace numbers to asterisks [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related