DEV Community

Arjun Shetty
Arjun Shetty

Posted on

Notes - Array in JSONB column

#postgres #database
  • Adding new rows 
INSERT INTO USER (DEPARTMENTS)
VALUES ('["dept1","dept2"]')
Enter fullscreen mode Exit fullscreen mode
  • Adding an new value to the column 
UPDATE USER
SET DEPARTMENTS = DEPARTMENTS || '["dept3"]'::JSONB
Enter fullscreen mode Exit fullscreen mode
  • Removing an value from the column 
UPDATE USER
SET DEPARTMENTS = DEPARTMENTS - '["dept1"]'::JSONB
Enter fullscreen mode Exit fullscreen mode

Top comments (0)