Regex in postgres update statement

Mar 20, 2015 • Lars Windolf –

--- categories: Postgres --- Want to use regular expressions in Postgres UPDATE statements?


BEGIN;
UPDATE table SET field=regexp_replace(field, 'match pattern', 'replace string', 'g');
END;