Re : Re : COPY form stdin and file
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 <tgl@sss.pgh.pa.us>
À : senges <csengstock@gmail.com>
Cc : pgsql-general@postgresql.org
Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s
Objet : Re: [GENERAL] COPY form stdin and file
"senges" <csengstock@gmail.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éponses
http://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éponses
http://fr.answers.yahoo.com
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
Show quoted text
On 5 Mrz., 15:23, laurent_ro...@yahoo.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@u
The Computing Froggy----- Message d'origine ----
De : Tom Lane <t...@sss.pgh.pa.us>
À : senges <csengst...@gmail.com>
Cc : pgsql-gene...@postgresql.org
Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s
Objet : Re: [GENERAL] COPY form stdin and file"senges" <csengst...@gmail.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 characterYou'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