Redirecting select() output generates error

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

Responses

Browse pgsql-general by date

  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