Re: COPY my_table FROM STDIN

From: Dave Page <dpage(at)postgresql(dot)org>
To: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: COPY my_table FROM STDIN
Date: 2007-01-17 08:21:59
Message-ID: 45ADDCA7.6000608@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Mathias Durst 2007-01-17 09:22:06 Re: PgAdmin Wishlist: export to clipboard
Previous Message Laurent ROCHE 2007-01-17 01:34:26 COPY my_table FROM STDIN