postgres-json-schema allows validation of JSON schemas in PostgreSQL. It is implemented as a PL/pgSQL function and you can use it as a check constraint to validate the format of your JSON columns.
This directory contains my collection of SQL puzzles. I hope you enjoy these puzzles as much as I have enjoyed creating them! To get started, open the Advanced SQL Puzzles Markdown.md. ⌨️ The ...