If you have the data already in a text file, you can upload the text
file to the server, then run "COPY xxxx FROM <path_to_file_on_server>"
from within PgAdmin, but if you have psql access, then use that as it's
much less hassle.
Dave Page wrote:
Laurent ROCHE wrote:
Hi,
I am trying to run a COPY my_table FROM STDIN from pgAdmin ... but I can not
manage to get it to work !
It runs with psql !
Here is a short version of the command:
COPY xfrt.import_cpts FROM STDIN;
1 DG 1 6930 7 JAN 07 1
2 DG 2 5430 7 JAN 07 2
3 DG 3 4617 7 JAN 07 3
\.
Am I missing something obvious ?
pgAdmin is not a console app - there is no easily usable stdin so you
cannot use COPY.
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
!DSPAM:37,45addcd5137102060715345!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
