From: ritchie turner <ritchie@ipowerhouse.com>
To: pgsql-sql@postgresql.org
Subject: COPY
Date: Mon, 17 Nov 2003 10:32:17 -0500
Message-ID: <200311171032.17362.ritchie@ipowerhouse.com> (raw)
In-Reply-To: <20031116051842.57962.qmail@web21404.mail.yahoo.com>
References: <20031116051842.57962.qmail@web21404.mail.yahoo.com>
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.
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
Thanks for any help
Ritchie
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ritchie@ipowerhouse.com
Subject: Re: COPY
In-Reply-To: <200311171032.17362.ritchie@ipowerhouse.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox