Converting Rows of One Table to JSON and Adding it to Another Table in PostgreSQL: A Practical Guide

Multiplying All Values of a JSON Object with PostgreSQL 9.6 Using Recursive CTE

Understanding How to Use PostgreSQL's SELECT Statement for Efficient Querying