Postgres Pro
Downloads
Home   >   mailing lists

Re: Emitting JSON to file using COPY TO - Mailing list pgsql-hackers

From Davin Shearer
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id CALvfUkDmDQNkXxP6Ci9z5KmD3FnR0H0zaC4-M6UN2tuedNT76g@mail.gmail.com
Whole thread Raw
In response to Re: Emitting JSON to file using COPY TO  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Tree view
I worked around it by using select json_agg(t)... and redirecting it to file via psql on the command line. COPY TO was working until we ran into broken JSON and discovered the double quoting issue due to some values containing " in them. 

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Is WAL_DEBUG related code still relevant today?
Next
From: Bharath Rupireddy
Date:
Subject: Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places