Integration with PostgreSQL (jsonb object column)

Thiago_Campos · March 31, 2020, 9:28pm

Hello Guys!!!

My integration is working, but the object column defined as jsonb has no “[]” in the structure as in the rx_info column. Is it a problem with the application server?

eugenev · March 31, 2020, 10:26pm

object is not an array of objects, [] not needed.

Thiago_Campos · April 1, 2020, 1:01am

I have error working on postgres if I use (object - >> ‘json1’) :: int as data1, witch object jsonb format is ‘{structure}’ but object jsonb format ‘[{structure}]’ work