Postgres Pro
Downloads
Home   >   mailing lists

Thread: COPY my_table FROM STDIN

COPY my_table FROM STDIN

From
Laurent ROCHE
Date:
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 ?




Cheers,
L@u
The Computing Froggy






___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com

Re: COPY my_table FROM STDIN

From
Dave Page
Date:
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.

Re: COPY my_table FROM STDIN

From
"Andy Shellam (Mailing Lists)"
Date:
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