Redirecting select() output generates error - Mailing list pgsql-general

From Rich Shepard
Subject Redirecting select() output generates error
Date
Msg-id alpine.LNX.2.20.1810291140010.17057@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Redirecting select() output generates error  (Rich Shepard <rshepard@appl-ecosys.com>)
List 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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: rw_redis_fdw: SQL Errors when statement is within a function
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Log file