Support pg_jsonschema as a PostgreSQL Extension
As a Software Engineer or DBA, I want to be able to enforce schemas on JSON/JSONB fields in a convenient manner, so that I can ensure bad data doesn't getting written to my database. https://github.com/supabase/pg_jsonschema seems to be the most popular extension for doing this.
7
votes
![](https://secure.gravatar.com/avatar/b82a9f4dd1d88dd1922224aa1b1123f4?size=40&default=https%3A%2F%2Fuvcdn.eu.uservoice.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Yauheni Savitski commented
Hi there,
we're also use jsonb is more and more frequently with our PostgreSQL instances. Also would like to introduce schema validation. Gonna definitely vote for introduction this extention