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

Reply via email to