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

From David G. Johnston
Subject Re: Redirecting select() output generates error
Date
Msg-id CAKFQuwZex6jN4ZHdL7MF_ZddJCqQHxq1bEGnK8wNPTd0-dVrBA@mail.gmail.com
Whole thread Raw
In response to Re: Redirecting select() output generates error  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Redirecting select() output generates error  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On Mon, Oct 29, 2018 at 12:30 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
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;

The "-#" prompt in psql means you are in line continuation mode.  The \out meta-command should be issued while sitting at an initial prompt "=#".

Being in line-continuation mode means you are typing something else above it that doesn't constitute a full command - and you are still not showing us what that is.  This is the reason I asked for basically a self-contained example.

David J.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Redirecting select() output generates error
Next
From: Rob Sargent
Date:
Subject: Re: Redirecting select() output generates error