From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Guillermo Reisch" <guillere(at)adinet(dot)com(dot)uy>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #2627: syntax error in COPY using pgAdmin III Query |
Date: | 2006-09-13 18:47:39 |
Message-ID: | 013e01c6d764$b8c96d00$6a01a8c0@valehousing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
pgAdmin doesn't support client side COPY.
Regards, Dave
-----Original Message-----
From: "Guillermo Reisch" <guillere(at)adinet(dot)com(dot)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(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | tomas | 2006-09-14 05:25:06 | Re: BUG #2626: Control de errores |
Previous Message | Tom Lane | 2006-09-13 18:20:31 | Re: BUG #2623: query optimizer not using indexes with inheritance and joins |