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, [EMAIL PROTECTED] (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, > [EMAIL PROTECTED] > The Computing Froggy > > ----- Message d'origine ---- > De : Tom Lane <[EMAIL PROTECTED]> > À : senges <[EMAIL PROTECTED]> > Cc : [EMAIL PROTECTED] > Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s > Objet : Re: [GENERAL] COPY form stdin and file > > "senges" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
