PostGres: Update Column with Array Values

Update an Array

UPDATE users SET topics = '{crows, cats}';

Append an Array

UPDATE users SET topics = topics || '{cats,mice}';

Append operation creates duplicates.

Reference

• https://makandracards.com/makandra/36097-postgresql-how-to-add-remove-modify-array-values-and-how-to-replace-1-value-with-multiple-values