Re: IS JSON STRICT - In oracle => postgres ??

On 14.06.23 12:00, Nikhil Ingale wrote:
> 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?

PostgreSQL 16 has an IS JSON predicate.

It doesn't have a STRICT clause, which I don't see in the SQL standard. 
So it might not do exactly the same thing.