| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Finding error in long input file |
| Date: | 2024-07-10 15:11:46 |
| Message-ID: | CAKFQuwYbQGo043MS_hEKnvdSjt2EFX7pd0BzNYV4D_gCA2CqdQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday, July 10, 2024, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> On Wed, 10 Jul 2024, David G. Johnston wrote:
>
> And what are the first few lines of the file? Use text, not screenshots.
>>
>
> David,
>
> insert into locations (company_nbr,loc_nbr,loc_name,
> addr1,city,state_code,postcode) values
> (2564,1,default,'4250 Hopkins Rd','Ontario','OR','97914'),
> (2565,1,default,'10695 Meridian Rd','Mount Angel','OR','97362'),
> (2566,1,default,'6963 Keene Rd NE','Gervais ','OR','97026'),
> (2567,1,default,'31250 S Bond Rd','Hubbard','OR','97032'),
>
My first easy look for this setup is for any single quotes not adjacent to
either a comma or a parenthesis. Syntax highlighting should ideally have
caught this but I’d look anyway.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2024-07-10 15:26:07 | Re: Finding error in long input file |
| Previous Message | Adrian Klaver | 2024-07-10 15:05:59 | Re: Finding error in long input file |