Re: COPY my_table FROM STDIN

If you have the data already in a text file, you can upload the text 
file to the server, then run "COPY xxxx FROM " 
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