Re: JSON data type and schema validation - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: JSON data type and schema validation
Date
Msg-id 5546E986.60609@dunslane.net
Whole thread Raw
In response to JSON data type and schema validation  (Dmitry Shirokov <deadrunk@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Dmitry Shirokov
Date:
Subject: JSON data type and schema validation
Next
From: Michael Paquier
Date:
Subject: Resource leak in pg_dump.c caused by transforms