COPY form stdin and file

Поиск
Список
Период
Сортировка
От senges
Тема COPY form stdin and file
Дата
Msg-id 1173083856.641103.146880@j27g2000cwj.googlegroups.com
обсуждение исходный текст
Ответы Re: COPY form stdin and file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: COPY form stdin and file  (Richard Huxton <dev@archonet.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Can I getting a unique ID from a select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY form stdin and file