Re: Redirecting select() output generates error

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Mon, 29 Oct 2018 12:30:01 -0700 (PDT)

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