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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: 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 17:10:15
Message-ID: b173d309-6f0f-45a2-075d-1cb94d02b528@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 arden liu 2020-04-05 17:30:26 Re: psql show me the : and ask user input, when running one sql file
Previous Message Adrian Klaver 2020-04-05 16:47:48 Re: psql show me the : and ask user input, when running one sql file