is is possible to run COPY query from pgadmin query window with data
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..
pgsql-novice by date
|Next:||From: Gurjeet Singh||Date: 2010-12-27 18:27:10|
|Subject: Re: COPY from PGAdmin|
|Previous:||From: 3dmashup||Date: 2010-12-26 18:17:55|
|Subject: Re: New indexing technique|