0
Answered

does vertabelo supports JSON, JSONB datatypes in postgresql

Shabarish Kesa 2 months ago updated by Jarosław Błąd (CEO) 2 months ago 2

Currenlty when i enter json or jsonb in the column data type, it throws unsupported data type error.

Does vertabelo supports json or jsonb data types?

Answered

Hello Shabarish,

json and jsonb datatypes are both supported by Vertabelo modeler. The problem in the example you have provided is Varchar() datatype. It is not allowed to use varchar without length. It should Varchar(length).

I hope this will help.