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

On Mon, 29 Oct 2018, David G. Johnston wrote:

> You can either use \out or \copy within psql script or redirect the shell
> output using shell features.

David,

willamette-river-hg-# \out data-summary-by-form.txt
willamette-river-hg-# 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

   Still not working.

Rich