Infos I didn't found that easily with Google and had to find out myself. Hereby given back to the net...
Regex in Postgres UPDATE Statement
Submitted by llando on Fri, 11/11/2011 - 11:35.
Want to use regular expressions in Postgres UPDATE statements?
BEGIN;
UPDATE table SET field=regexp_replace(field, 'match pattern', 'replace string', 'g');
END;
Post new comment