From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Redirecting select() output generates error |
Date: | 2018-10-29 18:46:35 |
Message-ID: | alpine.LNX.2.20.1810291140010.17057@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is puzzling and I've no idea what to do to fix it.
The table looks like this:
# select * from concentrations limit 2;
site_nbr | sampdate | medium | form | param | quant | unit | cen | floor | ceiling
----------+------------+---------+-------+-----------+-------+------+-----+-------+---------
10332 | 1979-11-06 | surface | total | inorganic | 0.5 | ug/L | 1 | 0 | 0.5
10332 | 1980-02-07 | surface | total | inorganic | 0.001 | ug/L | 1 | 0 | 0.001
Running this statement within psql works just fine (it's entered as a single
line but wrapped by alpine to fit the line limit):
select param, site_nbr, sampdate, min(quant), max(quant), unit from
concentrations group by param, site_nbr, sampdate, unit order by param,
site_nbr, sampdate, unit;
the output ends this way:
organic | 34198 | 2010-10-21 | 0.02 | 0.025 | ng/L
organic | 34198 | 2011-01-14 | 0.02 | 0.046 | ng/L
(585 rows)
But, when I try to redirect output to a disk file like this,
\o data-summary-by-form.txt
the result is an error:
# select param, site_nbr, sampdate, min(quant), max(quant), unit from concentrations group by param, site_nbr, sampdate, unit order by param, site_nbr, sampdate, unit;
ERROR: syntax error at or near "|"
LINE 1: | 1980-05-08 | 0.5 | 0.5 | ug/L
That line is not number 1 and I don't understand this behavior. Could it
be related to using hyphens in the filename rather than underscores?
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-10-29 18:56:06 | Re: Fwd: Log file |
Previous Message | Adrian Klaver | 2018-10-29 17:40:51 | Re: rw_redis_fdw: SQL Errors when statement is within a function |