Skip site navigation (1) Skip section navigation (2)


From: ritchie turner <ritchie(at)ipowerhouse(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: COPY
Date: 2003-11-17 15:32:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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 '|';
ERROR:  syntax error at or near "34" at character 108

Thanks for any help


In response to

pgsql-sql by date

Next:From: Tomasz MyrtaDate: 2003-11-17 15:35:07
Subject: Re: strange "not deferrable" behaviour
Previous:From: Stephan SzaboDate: 2003-11-17 15:18:18
Subject: Re: Addition and subtraction on BIT type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group