From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Multi-row insert: error at terminal row. |
Date: | 2020-10-29 16:39:48 |
Message-ID: | CAKFQuwasu2tSe96=ngfnVoS5+JHxZDC7ZTYpAoQcoSmASvQNgg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote:
>
> > That said seeing the first few rows, in addition to the last few, would
> > help.
>
> David,
>
> insert into organizations
> (org_nbr,org_name,org_url,org_email,industry,status,comment) values
> (1,'Tidewater Contractors Inc',null,null,'Mining','Opportunity','GEN12A'),
> (2,'All Rock LLC','www.allrockllc.com
> ',null,'Mining','Opportunity','GEN12A'),
> ...
>
>
As your general syntax seems correct I would suspect an issue in the data
values - like having a single quote in an organization name that isn't
properly escaped (doubled). I'd first make sure insert one record works
then begin bisecting your values, only inserting subsets at a time, until
you narrow down the offending record.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-10-29 16:45:37 | Re: Multi-row insert: error at terminal row. |
Previous Message | Rich Shepard | 2020-10-29 16:37:12 | Re: Multi-row insert: error at terminal row. |