[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

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' cases.

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

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

2007-03-05 Thread Laurent ROCHE
] À : 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 like this: - COPY mytable (id