pgAdmin doesn't support client side COPY. Regards, Dave
-----Original Message----- From: "Guillermo Reisch" <[EMAIL PROTECTED]> To: "[email protected]" <[email protected]> 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: [EMAIL PROTECTED] 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 ---------------------------(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
