Define a column type as JSONB/JSON in Data Model for PostGreSQL DB

[lpraba.23]

Hello

I want to define a column type as JSON or JSONB in data model.

Currently for Psotgresql the data type is not available in EA in the drop down.

Does anyone know how to get that data type to be displayed in EA tool ?

This is for PostGreSQL database.

Thanks

[Arshad]

Hi

You can define and add a new datatype for Postgresql.
Navigate to Configure > Reference Data > Settings > Database Datatypes

Choose Postgresql and add a type for JSON or JSONB (like below).  Once added can be used in defining columns



For more details refer Sparx help
https://sparxsystems.com/enterprise_architect_user_guide/14.0/model_domains/dbmsdatatypes.html


HTH
Arshad