Postgres Pro
Downloads
Home   >   mailing lists

Re: IS JSON STRICT - In oracle => postgres ?? - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: IS JSON STRICT - In oracle => postgres ??
Date
Msg-id 5be4f226-6838-acd5-f260-d1930a34580a@gmx.net
Whole thread Raw
In response to IS JSON STRICT - In oracle => postgres ??  (Nikhil Ingale <niks.bgm@gmail.com>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: How to use long list of columns with COPY command
Next
From: M Sarwar
Date:
Subject: The same result for with SPACE and without SPACE