COPY from PGAdmin

From: "Lukas" <lukas(at)fmf(dot)vgtu(dot)lt>
To: pgsql-novice(at)postgresql(dot)org
Subject: COPY from PGAdmin
Date: 2010-12-27 16:48:04
Message-ID: 4946.77.240.249.53.1293468484.squirrel@fmf.vgtu.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Gurjeet Singh 2010-12-27 18:27:10 Re: COPY from PGAdmin
Previous Message 3dmashup 2010-12-26 18:17:55 Re: New indexing technique