>>>>> "Matthias" == Matthias Apitz <guru@xxxxxxxxxxx> 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)
