Re : Re : [GENERAL] COPY form stdin and file

2007-03-05 Thread Laurent ROCHE
ROTECTED]> À : senges <[EMAIL PROTECTED]> Cc : pgsql-general@postgresql.org Envoyé le : Lundi, 5 Mars 2007, 10h22mn 22s Objet : Re: [GENERAL] COPY form stdin and file "senges" <[EMAIL PROTECTED]> writes: > when untaring a pg_dumped tar file the data gets populated li

Re: [GENERAL] COPY form stdin and file

2007-03-05 Thread Richard Huxton
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 kn

Re: [GENERAL] COPY form stdin and file

2007-03-05 Thread Tom Lane
"senges" <[EMAIL PROTECTED]> 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

[GENERAL] COPY form stdin and file

2007-03-05 Thread senges
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 ai