Skip to content

Instantly share code, notes, and snippets.

@peacefixation

peacefixation/postgres-find-replace.sql

Created April 20, 2021 02:59
Show Gist options
  • Save peacefixation/276a3ebab1559fc933d15fc6619e244a to your computer and use it in GitHub Desktop.
Save peacefixation/276a3ebab1559fc933d15fc6619e244a to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Find Replace
Raw
postgres-find-replace.sql
UPDATE table
SET column = REPLACE(column, 'find-str', 'replace-str')
WHERE id = X;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment