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

From Rob Sargent
Subject Re: Multi-row insert: error at terminal row.
Date
Msg-id 712da077-deec-6787-2ef0-3e668acfbc17@gmail.com
Whole thread Raw
In response to 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

On 10/29/20 9:43 AM, Rich Shepard wrote:
> I'm loading data into tables with the 'insert' statement. There are many
> rows containing values and each is bracketed by parentheses except for the
> last row. That's terminated with a semicolon, but psql reports an error
> there:
> 
> psql:organizations.sql:1926: ERROR:  syntax error at or near ";"
> LINE 1925: ...m',null,'Port','Opportunity',null);
>                                                  ^
> I'm not seeing why that's an error. All previous rows terminate with a 
> comma
> and I don't know where else to look for the reason. What am I missing
> seeing?
> 
> TIA,
> 
> Rich
> 
> 
> 

Can we see the last two line of the file (1924, 1925)?



pgsql-general by date:

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