Regex in postgres update statement

--- 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;