postgresql - How do I remove all spaces from a field in a Postgres database in an update query? - Stack Overflow

PHOTO EMBED

Mon Feb 20 2023 23:33:19 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

UPDATE users SET fullname = REPLACE(fullname, ' ', '') WHERE fullname ~* ' ';
content_copyCOPY

https://stackoverflow.com/questions/20376579/how-do-i-remove-all-spaces-from-a-field-in-a-postgres-database-in-an-update-quer