Re: Multi-row insert: error at terminal row. - Mailing list pgsql-general

From Paul Förster
Subject Re: Multi-row insert: error at terminal row.
Date
Msg-id 6FE34808-28CE-4550-9BC4-A70D91503D2C@gmail.com
Whole thread Raw
In response to Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Hi Rich,

> On 29. Oct, 2020, at 16:58, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> On Thu, 29 Oct 2020, Rob Sargent wrote:
>
>> Can we see the last two line of the file (1924, 1925)?
>
> Rob,
>
> (2697,'Port of Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
> (2698,'Port of Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
>
> Each line is enclosed in parentheses and is terminated with a comma.

the last line has a closing parenthesis missing.

Cheers,
Paul


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Multi-row insert: error at terminal row.
Next
From: Rich Shepard
Date:
Subject: Re: Multi-row insert: error at terminal row.