Re: Re : Re : COPY form stdin and file

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(dot)(dot)(dot)(at)yahoo(dot)com (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(at)u
> The Computing Froggy
>
> ----- Message d'origine ----
> De : Tom Lane <t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us>
> À : senges <csengst(dot)(dot)(dot)(at)gmail(dot)com>
> Cc : pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org
> Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s
> Objet : Re: [GENERAL] COPY form stdin and file
>
> "senges" <csengst(dot)(dot)(dot)(at)gmail(dot)com> 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