Re: Replace string - Mailing list pgsql-sql

> test=*# select regexp_replace(regexp_replace('The blue fox\'s fur.', ' ', '-', 'g'), '\\.', '');
>    regexp_replace
> --------------------
>  The-blue-fox's-fur
> (1 row)
>
>
> Andreas
>   
Thanks for the input.


I came up with this:

REPLACE(regexp_replace('The blue fox\'s fur', '[[:punct:]]', ''), ' ', '-');