On Mon, Mar 30, 2015 at 12:54 PM, Deven Phillips <deven.phillips@xxxxxxxxx> wrote: > Hi all, > > I have a query which selects several rows of data, and contained in one > of those rows is some aggregated JSON data. I am using row_to_json() to make > the whole output JSON and I am providing "true" for pretty formatting of the > JSON. The problem that I am seeing is that they nested JSON block is not > being prettified along with the outer JSON. It looks like a bug. The 'outer' to_json's pretty print feature should control the whole structure IMO. Personally, I think you'll have better luck rigging another function to do whitespace insertion formatting. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general