Re: [SQL] Replace string

[PostgreSQL Admin]

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend