Re: COPY from PGAdmin - Mailing list pgsql-novice

Hello,

 is is possible to run COPY query from pgadmin query window with data
"from stdin"?
 I am trying with example:
COPY phone (ph_id, ph_phone, ph_name) FROM stdin;
1       37061054322     John
2       37065992332     Tom
\.

But I get error:
ERROR:  syntax error at or near "1"
LINE 2: 1 37061054322 John
       ^

I analyzed plain text dump file of the same table, and I see that it is
the same query, but it do not work from pgadmin..


---
Lukas
UAB nSoft
www.nSoft.lt


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice