Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY my_table FROM STDIN - Mailing list pgadmin-support

From Dave Page
Subject Re: COPY my_table FROM STDIN
Date
Msg-id 45ADDCA7.6000608@postgresql.org
Whole thread Raw
In response to COPY my_table FROM STDIN  (Laurent ROCHE <laurent_roche@yahoo.com>)
Responses Re: COPY my_table FROM STDIN  ("Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>)
List pgadmin-support
Tree view 
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.

pgadmin-support by date:

Previous
From: Laurent ROCHE
Date:
Subject: COPY my_table FROM STDIN
Next
From: Mathias Durst
Date:
Subject: Re: PgAdmin Wishlist: export to clipboard