Database Reference
In-Depth Information
Adding data to a user-defined column
The syntax for a user-defined type literal is similar to that of a map literal, except that the
keys are identifiers rather than literal values. For instance, we can re-add
alice
's educa-
tion information into our new column as follows:
UPDATE "users"
SET "education" = {
"school_name": 'Big Data University',
"graduation_year": 2003
}
WHERE "username" = 'alice';
Now we can observe that the
education
information is present in
alice
's profile: