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