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