senges wrote:
Hi all,
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' ;
-----------------
where $$PATH$$ gets replaced by the current path.
Anyone knows whats the aim of this ?
The ".\" throws an error within the pgadmin sql query window:
ERROR: syntax error at or near "\" at character
The "\." on a separate line ends the COPY ... FROM stdin above it.
I'm not sure pgadmin has a "stdin" to process data from though.
pg_restore is probably the tool you want to use.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly