remove special characters from in the being and end of a string value postgresql code example
Example: postgres regex remove special characters
UPDATE ex_cat_fda
SET name = regexp_replace(name, '[^a-zA-Z0-9]+', '','g');
UPDATE ex_cat_fda
SET name = regexp_replace(name, '[^a-zA-Z0-9]+', '','g');