From: | "senges" <csengstock(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | COPY form stdin and file |
Date: | 2007-03-05 08:37:36 |
Message-ID: | 1173083856.641103.146880@j27g2000cwj.googlegroups.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Isn't it correct just to call:
# copy mytable (id, attr1, attr2) from '$$PATH$$/2387.dat' ; ?
Its kind of unrelaxed to untar a restored db (which i need to untar
from time to time because of changing libraries) and always need to
change the above lines of code.
Thanks for any info about this,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-03-05 09:15:05 | Re: COPY form stdin and file |
Previous Message | Bruno Wolff III | 2007-03-05 08:35:42 | Re: Can I getting a unique ID from a select |