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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux