Re: COPY my_table FROM STDIN

["Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>]

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