using regexp_replace to remove special chracter postgresql

PHOTO EMBED

Fri Mar 18 2022 03:15:33 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select *, regexp_replace(t1, '[[:digit:]]+', '','g') -- remove all number in t1
from
(
select *, 
regexp_replace(name, '[^a-zA-Z0-9]+', '','g')as t1 -- remove all special lcharacter
,regexp_replace(number, '[^a-zA-Z0-9]+', '','g') as t2 --remove all special character
from remove_specialcharacter_csv as rsc 
) tt
content_copyCOPY