If you have the data already in a text file, you can upload the text
file to the server, then run "COPY FROM "
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
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;
> 1DG 16930 7 JAN 071
> 2DG 25
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;
1DG 16930 7 JAN 071
2DG 25430 7 JAN 072
3DG 34617