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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: IS JSON STRICT - In oracle => postgres ??
Date: 2023-06-14 10:15:58
Message-ID: ZImTXsqhJPs5urBa@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jun 14, 2023 at 03:30:50PM +0530, Nikhil Ingale wrote:
> Hi All,
> 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?

Well, if the data is in json(b) column, then it is well formed, isn't
it?

Best regards,

depesz

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2023-06-14 10:19:01 Re: How to read wal files in postgresql 15?
Previous Message Nikhil Ingale 2023-06-14 10:00:50 IS JSON STRICT - In oracle => postgres ??