COPY form stdin and file

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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