On JSON and SQL
See the articles:
http://tapoueh.org/blog/2017/09/on-json-and-sql/ http://tapoueh.org/blog/2017/10/set-returning-fonctions-and-postgresql-10/
To use the files:
$ createdb magic
$ psql -d magic -a -f magic.create.sql
$ PGOST=... PGPORT=... PGDATABASE=magic python3 magic.py
$ psql -d magic -a -f magic.sql
Details at the blog post articles.
The Art of PostgreSQL
Second Edition, Updated (2026)
PostgreSQL 10 through 18, a new pgvector chapter, 56 new figures, and a free practice lab.
See what's new →