>>>>> "Matthias" == Matthias Apitz <guru@unixarea.de> writes:
Matthias> it is exported into the file as
Matthias> cmd \| lpr ...
Matthias> because the export delimiter is set to '|';
Matthias> the COPY in text mode was complaining because it interpreted
Matthias> the | of the sequence \| as an delimiter and the number of
Matthias> columns did not matched.
Matthias> I will provide tomorrow the exact input line, the exact COPY
Matthias> command and the error.
This worked for me:
postgres=# copy ct(a,b,c,d,e) from stdin with delimiter '|';
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself, or an EOF signal.
>> 0|1| cat $1 \| lpr -Pprinter |3|4
>> \.
COPY 1
--
Andrew (irc:RhodiumToad)