Database Trigger Procedure in Postgres

An introduction to triggers in Postgres

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

%d bloggers like this: