Re: [pgadmin-support] COPY my_table FROM STDIN

2007-01-17 Thread Andy Shellam (Mailing Lists)
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

Re: [pgadmin-support] COPY my_table FROM STDIN

2007-01-17 Thread Dave Page
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

[pgadmin-support] COPY my_table FROM STDIN

2007-01-16 Thread Laurent ROCHE
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