From 65f8bcb166d34ae8038b354fd00cb20ef950fdb5 Mon Sep 17 00:00:00 2001
From: Sergey Matveev <stargrave@stargrave.org>
Date: Thu, 25 Jan 2018 11:07:56 +0300
Subject: [PATCH] =?utf8?q?Pretty=20print=20JSONB=20=D0=B2=20PostgreSQL?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Использую вот такие две функи в .psqlrc для простого вывода и просто
JSONB полей и массивов JSONB:

    CREATE OR REPLACE FUNCTION ppj(jsonb) RETURNS TEXT AS $$
        SELECT jsonb_pretty($1);
    $$ LANGUAGE SQL;
    CREATE OR REPLACE FUNCTION ppj(jsonb[]) RETURNS SETOF TEXT AS $$
        SELECT jsonb_pretty(unnest) FROM (SELECT unnest($1)) AS dummy;
    $$ LANGUAGE SQL;
-- 
2.48.1