# pg\_jsonschema: JSON Schema support for Postgres

DevFeed: [pg\_jsonschema: JSON Schema support for Postgres](<https://devfeed.tech/articles/pg-jsonschema-json-schema-support-for-postgres-484.md>)

Original publisher: [Read original article](<https://supabase.com/blog/pg-jsonschema-a-postgres-extension-for-json-validation>)

Author: Oliver Rice

Published: 2022-08-19T07:00:00Z

Content type: article

Language: en

Sources: [Supabase Blog](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [JSON Schema](<https://devfeed.tech/topics/json-schema.md>), [JSON](<https://devfeed.tech/topics/json.md>), [Supabase](<https://devfeed.tech/topics/supabase.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [json](<https://devfeed.tech/tags/json.md>), [json-schema](<https://devfeed.tech/tags/json-schema.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [sql](<https://devfeed.tech/tags/sql.md>), [validation](<https://devfeed.tech/tags/validation.md>)

## AI overview

Supabase introduces pg_jsonschema, a Postgres extension that adds JSON Schema validation for JSON data. The article explains how validating document-shaped webhook payloads can preserve flexibility while enforcing required structure and constraints.

## Source excerpt

Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.