Code Snippets
Created by renews

programming
development
snippets

QR Code
Code Snippets

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 column data in place with Postgres 
UPDATE your_table
SET your_column = REGEXP_REPLACE(your_column, '\/path\/to\/resource', '/new/path', 'g')
WHERE your_column ~ '\/path\/to\/resource';
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!