Add the ‘g’ option. See the PgSQL docs
> On Mar 30, 2020, at 3:10 AM, Shaozhong SHI <[email protected]> wrote: > > I ran the following code. > > ---strip special characters > area_name = regexp_replace(area_name, '[^\w]+',''); > > It only stripped away the first bracket - (. But, it left the closing > bracket ). > > I had to run it twice in order to stripped the second. > > Is there a robust way to strip off special characters? > > Regards, > > Shao > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
