Re: COPY my_table FROM STDIN

[Dave Page <dpage(at)postgresql(dot)org>]

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.