Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

 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..

UAB nSoft


pgsql-novice by date

Next:From: Gurjeet SinghDate: 2010-12-27 18:27:10
Subject: Re: COPY from PGAdmin
Previous:From: 3dmashupDate: 2010-12-26 18:17:55
Subject: Re: New indexing technique

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group