Skip to main content

One doc tagged with "json"

View all tags

JSON Schema Validation

PostgreSQL offers native support for JSON and JSONB data types, allowing you to store JSON documents directly in your tables. However, ensuring that these JSON documents adhere to a specific schema requires additional mechanisms. There are extensions like json-schema and json-schema-validator that can be used to validate JSON documents against a schema. We can do simple validation without relying on extensions.