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.