Append to array

sql

UPDATE user_profiles SET tags = array_append(tags, 'vip') WHERE user_id = 42;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing JSONB, Arrays, and Date/Time Recipes

Modify matching rows.

Open In sheetsql1 tag match

Update rows using another table in the same statement.

Open In sheetsql1 tag match

Turn array elements into rows.

Open In sheetsql1 tag match

Open an interactive psql session to a database.

Create a new database in the cluster.

Create a namespace for objects.