Quick Links

IS JSON STRICT - In oracle => postgres ??

From:	Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
To:	pgsql-admin(at)lists(dot)postgresql(dot)org
Subject:	IS JSON STRICT - In oracle => postgres ??
Date:	2023-06-14 10:00:50
Message-ID:	CALXkTpx66eJKJM1YPFmYJNJwn2LeGAb7qkiXkhyOGBCoKA4isQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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?

Regards,
Nikhil Ingale

Responses

Re: IS JSON STRICT - In oracle => postgres ?? at 2023-06-14 10:15:58 from hubert depesz lubaczewski
Re: IS JSON STRICT - In oracle => postgres ?? at 2023-06-14 14:09:14 from Holger Jakobs
Re: IS JSON STRICT - In oracle => postgres ?? at 2023-06-14 15:03:27 from Thomas Kellerer
Re: IS JSON STRICT - In oracle => postgres ?? at 2023-06-20 08:07:05 from Peter Eisentraut

Browse pgsql-admin by date

	From	Date	Subject
Next Message	hubert depesz lubaczewski	2023-06-14 10:15:58	Re: IS JSON STRICT - In oracle => postgres ??
Previous Message	Holger Jakobs	2023-06-12 21:02:12	Re: How to use long list of columns with COPY command