Re: JSON data type and schema validation

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Dmitry Shirokov <deadrunk(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: JSON data type and schema validation
Date: 2015-05-04 03:37:42
Message-ID: 5546E986.60609@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 05/03/2015 11:20 PM, Dmitry Shirokov wrote:
> Hi all,
>
> Are there any plans to introduce in next versions of Postgres a schema
> validation for JSON field type? It would be very nice to have a
> support of something like json-schema spec, see
> http://json-schema.org/documentation.html. Right now there's the only
> way to do it via individual constraints, which is not very convenient
> in most cases. Please correct me if I'm wrong.
>
>

Not that I know of. It should be possible to do as an extension and
applied with a check constraint.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-05-04 04:34:28 Resource leak in pg_dump.c caused by transforms
Previous Message Dmitry Shirokov 2015-05-04 03:20:15 JSON data type and schema validation