Nikhil Ingale schrieb am 14.06.2023 um 12:00: > In oracle we can use the *is json* check constraint for the json column to ensure the data is well formed. > > How do we ensure the same in postgres database? That check constraint isn't necessary in Postgres. A column defined as jsonb (or json) will not accept invalid JSON. That's pretty much the behaviour that's introduced in Oracle 23 with the new JSON data type.
