BUG #2627: syntax error in COPY using pgAdmin III Query - Mailing list pgsql-bugs

From Guillermo Reisch
Subject BUG #2627: syntax error in COPY using pgAdmin III Query
Date
Msg-id 200609131802.k8DI2brT062916@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2627
Logged by:          Guillermo Reisch
Email address:      guillere@adinet.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

pgsql-bugs by date:

Previous
From: "Fernando chamber hurtado"
Date:
Subject: BUG #2626: Control de errores
Next
From:
Date:
Subject: pgsql on Solaris 10