> 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:]]', ''), ' ', '-');