X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BF7F8D1BA81 for ; Mon, 17 Nov 2003 18:33:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18196-10 for ; Mon, 17 Nov 2003 14:33:10 -0400 (AST) Received: from turkey.mail.pas.earthlink.net (turkey.mail.pas.earthlink.net [207.217.120.126]) by svr1.postgresql.org (Postfix) with ESMTP id BAFE9D1C4DD for ; Mon, 17 Nov 2003 14:33:08 -0400 (AST) Received: from 209-165-4.60.lightspeed.net ([209.165.4.60]) by turkey.mail.pas.earthlink.net with esmtp (Exim 3.33 #1) id 1ALoBA-0001zQ-00 for pgsql-sql@postgresql.org; Mon, 17 Nov 2003 10:32:52 -0800 From: ritchie turner Organization: ipowerhouse.com To: pgsql-sql@postgresql.org Subject: COPY Date: Mon, 17 Nov 2003 10:32:17 -0500 User-Agent: KMail/1.5.1 References: <20031116051842.57962.qmail@web21404.mail.yahoo.com> In-Reply-To: <20031116051842.57962.qmail@web21404.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200311171032.17362.ritchie@ipowerhouse.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/205 X-Sequence-Number: 16020 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