COPY support

From: ritchie turner <ritchie(at)ipowerhouse(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: COPY support
Date: 2003-11-17 22:30:06
Message-ID: 200311171730.06737.ritchie@ipowerhouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-11-18 04:25:20 Re: COPY support
Previous Message Gerald Dalley 2003-11-17 14:26:06 unsubscribe pgsql-jdbc