Обсуждение: COPY my_table FROM STDIN
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 ? Cheers, L@u The Computing Froggy ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com
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.
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