Storing JSONB in Postgres
Has anyone used the JSONB field type in Postgres?
I’m trying to store in that field using either binary or character as the data type for the schema and Postgres is complaining that there is a data mismatch.
Native error code: -1 – ERROR: column “release_automation_data” is of type jsonb but expression is of type text
I have tried setting the schema data type to character, binary & object and always the same message.
What should the column in the Studio schema be defined as?