Re: JSON data type and schema validation

From: Evgeniy Shishkin <itparanoia(at)gmail(dot)com>
To: Dmitry Shirokov <deadrunk(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: JSON data type and schema validation
Date: 2015-05-04 09:24:06
Message-ID: 25D7D080-A3D5-4C3D-AE2E-E2B7BC2655AF@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> On 04 May 2015, at 06:20, Dmitry Shirokov <deadrunk(at)gmail(dot)com> 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.
>

Take a look at https://github.com/akorotkov/jsquery
You can find schema validation example in docs.

> Cheers,
> Dmitry

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-05-04 09:26:18 Re: psql :: support for \ev viewname and \sv viewname
Previous Message Bernd Helmle 2015-05-04 09:22:33 Re: cost_index() and path row estimate.