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.