As u said it's working with the 'psql' client after replaceing $$PATH$ $ with the directory where i unpacked the backup file. /> psql -f restore.sql Thanx, Chris On 5 Mrz., 15:23, laurent_ro...@xxxxxxxxx (Laurent ROCHE) wrote: > COPY FROM stdin works only from a console ... and PGAdmin is not a console but a window environment, so that does not work ! > I had the PG Admin explaining the very same things, before. > > Cheers, > L@u > The Computing Froggy > > ----- Message d'origine ---- > De : Tom Lane <t...@xxxxxxxxxxxxx> > À : senges <csengst...@xxxxxxxxx> > Cc : pgsql-gene...@xxxxxxxxxxxxxx > Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s > Objet : Re: [GENERAL] COPY form stdin and file > > "senges" <csengst...@xxxxxxxxx> writes: > > when untaring a pg_dumped tar file the data gets populated like this: > > ----------------- > > COPY mytable (id, attr1, attr2) FROM stdin; > > \. > > copy mytable (id, attr1, attr2) from '$$PATH$$/2387.dat' ; > > ----------------- > > Not here ... I only see 'FROM stdin' cases. Please provide a test case, > and mention which PG version you are dealing with. > > > The ".\" throws an error within the pgadmin sql query window: > > ERROR: syntax error at or near "\" at character > > You'd need to complain to the pgadmin people about that. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > > ___________________________________________________________________________ > 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éponseshttp://fr.answers.yahoo.com > > ___________________________________________________________________________ > 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éponseshttp://fr.answers.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
