× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2013-11-14T18:42:31Z  · last modified 2013-11-15T00:10:56Z

Include JSON datatype for PostgreSQL 9.1 and above in ER Diagram Table Properties


customer request
Dev
Ivan Gron
ivangron
QA swissarmyknife(*)
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 14.0

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.

2 attachments

Issue #10770

Closed
Fixed
Resolved 2013-11-14T20:52:24Z
 
 
Completion
No due date
Fixed Build v14.0.6
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017