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; Please enable JavaScript to view the comments powered by Disqus.