Re: psql show me the : and ask user input, when running one sql file

From: arden liu <ardenbook(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: 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 17:51:34
Message-ID: CAK0Kdk=2mKy9hL0wMcDOJrcLYOdesSdLz_yYNBp0=wRgfHAY-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does that RETURNING need any user input?

On Sun., Apr. 5, 2020, 1:10 p.m. Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com>
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:
>
> ...
> CREATE TABLE
> ALTER TABLE
> INSERT 0 4333
> INSERT 0 9326
> INSERT 0 13
> ALTER TABLE
> ALTER TABLE
> ...
>
> >
> >
> >
> >> Thanks.
> >> Arden
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-05 18:09:03 Re: psql show me the : and ask user input, when running one sql file
Previous Message arden liu 2020-04-05 17:32:09 Re: psql show me the : and ask user input, when running one sql file