Redirecting select() output generates error
От | Rich Shepard |
---|---|
Тема | Redirecting select() output generates error |
Дата | |
Msg-id | alpine.LNX.2.20.1810291140010.17057@salmo.appl-ecosys.com обсуждение исходный текст |
Ответы |
Re: Redirecting select() output generates error
|
Список | 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 по дате отправления: