The following bug has been logged online:

Bug reference: 2627
Logged by: Guillermo Reisch
Email address: guillere (AT) adinet (DOT) com.uy
PostgreSQL version: 8.1.4-1
Operating system: Windows XP SP2
Description: syntax error in COPY using pgAdmin III Query
Details:

Problem to fill a table using COPY.
I have a SQL file (table1.sql) with the information of tabla1 to put using
commando Copy, if run script file with "pgAdmin III" using the "tools=>Query
tool" it generate an error. However if I run script from “psql to
'posgres'” using the option "\i table1.sql" , it works perfectly.

table1 info:

CREATE TABLE table1
(
col1 int4,
col2 int4,
col3 int4
)
WITHOUT OIDS;
ALTER TABLE table1 OWNER TO postgres;

File table1.sql:
----------------------------------------------

COPY table1 (col1, col2, col3) FROM stdin;
5 10 15
20 30 40
7 8 0
\.

----------------------------------------------

Output mensaje from pgAdmin III Query:
ERROR: syntax error at or near "5" at character 61

steps to follow to produce the error:
1 Create table1(int4, int4, int4)
2 open tools=>Query tool
3 load "table1.sql"
4 run script

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

pgAdmin doesn't support client side COPY.

Regards, Dave

-----Original Message-----
From: "Guillermo Reisch" <guillere (AT) adinet (DOT) com.uy>
To: "pgsql-bugs (AT) postgresql (DOT) org" <pgsql-bugs (AT) postgresql (DOT) org>
Sent: 13/09/06 19:09
Subject: [BUGS] BUG #2627: syntax error in COPY using pgAdmin III Query


The following bug has been logged online:

Bug reference: 2627
Logged by: Guillermo Reisch
Email address: guillere (AT) adinet (DOT) com.uy
PostgreSQL version: 8.1.4-1
Operating system: Windows XP SP2
Description: syntax error in COPY using pgAdmin III Query
Details:=20

Problem to fill a table using COPY.
I have a SQL file (table1.sql) with the information of tabla1 to put using
commando Copy, if run script file with "pgAdmin III" using the "tools=3D>Qu=
ery
tool" it generate an error. However if I run script from =C3=A2=E2=82=AC=C5=
=93psql to
'posgres'=C3=A2=E2=82=AC=C2=9D using the option "\i table1.sql" , it works =
perfectly.=20

table1 info:

CREATE TABLE table1
(
col1 int4,
col2 int4,
col3 int4
)=20
WITHOUT OIDS;
ALTER TABLE table1 OWNER TO postgres;

File table1.sql:
----------------------------------------------

COPY table1 (col1, col2, col3) FROM stdin;
5 10 15
20 30 40
7 8 0
\.

----------------------------------------------

Output mensaje from pgAdmin III Query:
ERROR: syntax error at or near "5" at character 61

steps to follow to produce the error:
1 Create table1(int4, int4, int4)
2 open tools=3D>Query tool
3 load "table1.sql"
4 run script

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match