COPY support
От | ritchie turner |
---|---|
Тема | COPY support |
Дата | |
Msg-id | 200311171730.06737.ritchie@ipowerhouse.com обсуждение исходный текст |
Ответы |
Re: COPY support
|
Список | pgsql-jdbc |
Hi all I'm trying to optimise some sql inserts I have by using the COPY command instead. I'm connecting from Java using 7.4 beta 3. It works at the command line, but I can't get it to work from Java. I'm doing an executeUpdate() on the COPY string below in the hope it works, but .... Here's the pg log output. LOG: query: COPY bingo_cards (account_id, game_id, win_ball, card, current_call, state) FROM stdin with delimiter '|'; 34|50558|75|3,7,8,4,12,23,18,24,22,21,38,45,42,39,43,55,54,53,51,46,70,66,71,75,65|0|0 34|50558|68|4,8,2,13,11,26,23,30,19,18,39,35,31,36,43,55,60,48,59,58,72,68,65,71,66|0|0 34|50558|72|15,11,2,4,5,26,18,20,25,27,43,36,45,38,31,54,57,58,55,50,66,73,71,72,69|0|0 \. ERROR: syntax error at or near "34" at character 108 I see there was some traffic on this list regard special copy support in the driver, did it make it in? Can't see it. Thanks for any help. Ritchie
В списке pgsql-jdbc по дате отправления: