Update column data in place with Postgres
From the collection Code Snippets

postgres
snippet

QR Code
Update column data in place with Postgres

You can show this QR Code to a friend or ask them to scan directly on your screen!

Thanks for sharing! 🫶

The url for this was also copied to your clipboard! 
UPDATE your_table
SET your_column = REGEXP_REPLACE(your_column, '\/path\/to\/resource', '/new/path', 'g')
WHERE your_column ~ '\/path\/to\/resource';
See more from renews