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

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: IS JSON STRICT - In oracle => postgres ??
Date: 2023-06-14 15:03:27
Message-ID: 5be4f226-6838-acd5-f260-d1930a34580a@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-06-14 21:07:50 The same result for with SPACE and without SPACE
Previous Message M Sarwar 2023-06-14 14:51:24 Re: How to use long list of columns with COPY command