Database Reference
In-Depth Information
Writing a map
Like sets and lists, maps have a literal syntax that allows you to directly set the entire con-
tents of a column:
UPDATE "users"
SET "social_identities" = {'twitter': 353637}
WHERE "username" = 'alice';
The literal syntax for a map separates keys and values with a colon and optional
whitespace, delimits key-value pairs with commas, and encloses the whole thing in curly
braces. Both keys and values themselves are written in the literal format for their type.
