Postgresql regex match all digits in column

Question

How do I extract all digits from a string with regex in pgsql?

select regexp_matches('dsa8a552a5a2a5?', '\d+');

Will output only 8.

Need to get 8552525

You're actually right. I'll change it to better comply with the rules — Fabrizio Mazzoni, May 31, 2015 at 14:01

Daniel Vérité · Accepted Answer · 2015-05-30 13:00:10Z

3

Better use regexp_replace, globally replacing non-digits by an empty string:

select regexp_replace('dsa8a552a5a2a5?', '\D', '', 'g');

 regexp_replace 
----------------
 8552525

answered May 30, 2015 at 13:00

Daniel Vérité

29.8k3 gold badges68 silver badges78 bronze badges

I like the posix variant of the same thing: regexp_replace('dsa8a552a5a2a5?', '[^[:digit:]]','','g')
– Kirk Roybal
Jun 8, 2015 at 19:57

Add a comment |

1 Answer 1