Re: Finding error in long input file
David G. Johnston <david.g.johnston@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2024-07-10T15:11:46Z
Lists: pgsql-general
On Wednesday, July 10, 2024, Rich Shepard <rshepard@appl-ecosys.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.