Re: Finding error in long input file
| От | David G. Johnston |
|---|---|
| Тема | Re: Finding error in long input file |
| Дата | |
| Msg-id | CAKFQuwYbQGo043MS_hEKnvdSjt2EFX7pd0BzNYV4D_gCA2CqdQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Finding error in long input file (Rich Shepard <rshepard@appl-ecosys.com>) |
| Ответы |
Re: Finding error in long input file
|
| Список | 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.
В списке pgsql-general по дате отправления: