Notice the following in the PostgreSQL documentation for 9.2
http://www.postgresql.org/docs/9.2/static/datatype-json.html
The json data type can be used to store JSON (JavaScript Object Notation) data, as specified in RFC 4627. Such data can also be stored as text, but the json data type has the advantage of checking that each stored value is a valid JSON value. There are also related support functions available; see Section 9.15.
There is a difference between storing as TEXT and JSON. JSON fields are not only validated as correct JSON on insert, but you can also index the JSON keys themselves.
When using the Visual Editor to CREATE a table from the Schema Browser you can create a table column with the datatype JSON for PostgreSQL, we just don't allow this datatype in the dropdown for the ER Modeler Table Properties for PostgreSQL.
See attached.
Should be for PostgreSQL 9.2 and above, as it was new in 9.2
see "What's new in PostgreSQL 9.2"
http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#JSON_datatype
Added JSON support to ERM as of postgres 9.2 and above.
Added JSON support to ERM as of postgres 9.2 and above.
looks good in
looks good in
Was already there for Visual Editor CREATE/ALTER Table GUI since at least v13. Just wasn't visible as a choice for datatype within the ER Model Table Properties.
Was already there for Visual Editor CREATE/ALTER Table GUI since at least v13. Just wasn't visible as a choice for datatype within the ER Model Table Properties.
Issue #10770 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v14.0.6 |
No time estimate |
Should be for PostgreSQL 9.2 and above, as it was new in 9.2
see "What's new in PostgreSQL 9.2"
http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#JSON_datatype