when in psql:
postgres=# EXPLAIN (ANALYSE, FORMAT JSON) SELECT a FROM t;
QUERY PLAN
-------------------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Merge Join", +
"Parallel Aware": false, +
"Async Capable": false, +
"Join Type": "Inner", +
"Startup Cost": 2185.43, +
How can I get valid json output, ie rid of the header and '+' signs?
when in psql:
postgres=# EXPLAIN (ANALYSE, FORMAT JSON) SELECT a FROM t;
QUERY PLAN
-------------------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Merge Join", +
"Parallel Aware": false, +
"Async Capable": false, +
"Join Type": "Inner", +
"Startup Cost": 2185.43, +
How can I get valid json output, ie rid of the header and '+' signs?
Share Improve this question asked Mar 22 at 17:16 oran goran g 1811 silver badge12 bronze badges1 Answer
Reset to default 3You use a default output format in psql. This use + sign as a symbol for new line. You can switch to unaligned mode instead. Disable pager can be good idea too (for mentioned purpose):
postgres=# select e'ahoj\nnazdar';
+----------+
| ?column? |
+----------+
| ahoj +|
| nazdar |
+----------+
(1 row)
postgres=# \pset format unaligned
Output format is unaligned.
postgres=# select e'ahoj\nnazdar';
?column?
ahoj
nazdar
(1 row)
You can find a description of available formats and format possibilities in related doc https://www.postgresql./docs/current/app-psql.html