| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "arden liu" <ardenbook(at)gmail(dot)com>,pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: psql show me the : and ask user input, when running one sql file |
| Date: | 2020-04-05 18:32:36 |
| Message-ID: | 394935db-136e-436d-8971-addd6b1a4e03@manitou-mail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver wrote:
> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > On 4/5/20 5:50 AM, arden liu wrote:
>
> > 4) I don't see anything wrong the statements, so I am wondering if it is
> > a shell issue?
>
> Seems to be. I removed the RETURNING *_id from the INSERT statements and
> the file ran without interruption:
Presumably these results are being displayer with a pager, and it's
the pager that is asking for keyboard input.
You may add -P pager=off to psql options to suppress this,
or remove permanently the RETURNING clauses that seem pointless
in that context.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
| From | Date | Subject | |
|---|---|---|---|
| Next Message | arden liu | 2020-04-05 18:46:48 | Re: psql show me the : and ask user input, when running one sql file |
| Previous Message | arden liu | 2020-04-05 18:29:34 | Re: psql show me the : and ask user input, when running one sql file |