From: | Eugene Lee <eugene(at)anime(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | COPY syntax in ColdFusion |
Date: | 2001-04-27 06:26:06 |
Message-ID: | 20010426232606.A19645@anime.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Does anyone have experience using the COPY command in ColdFusion to
populate a table? Doing it from the command line is easy, but I can't
seem to get the right syntax within a ColdFusion query. I have a table
called "category":
# \d categories
Table "categories"
Attribute | Type | Modifier
------------+----------+----------
productid | text |
category | text |
catid | smallint |
index | smallint |
And this is the ColdFusion code I'm using:
<CFQUERY NAME="populatetablequery" DATASOURCE="productdb" DBTYPE="ODBC">
COPY categories FROM STDIN ;
304 ALUM Aluminum 1 1
9415 Aluminum 1 2
324 Aluminum 1 3
\.
</CFQUERY>
If I cut-and-paste the query, it works. But within ColdFusion, I get
this PostgreSQL error:
Apr 27 00:42:05 localhost logger: ERROR: parser: parse error at or near "304"
Apr 27 00:42:05 localhost logger: pq_recvbuf: unexpected EOF on client connection
Apr 27 00:42:05 localhost logger: ERROR: parser: parse error at or near "304"
Apr 27 00:42:05 localhost logger: pq_flush: send() failed: Broken pipe
Apr 27 00:42:05 localhost logger: pq_recvbuf: unexpected EOF on client connection
This is with PostgreSQL 7.1. For the best performance and avoiding
server timeouts, I'd rather not insert one record at a time. Anyways,
thanks in advance for any tips.
--
Eugene Lee
eugene(at)anime(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Renaud Thonnart | 2001-04-27 06:54:42 | Messages from PostgreSQL |
Previous Message | Jeff Waugh | 2001-04-27 06:16:35 | Re: Classes of returned rows |