Re: Two small questions re/ COPY CSV data into table

>>>>> "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)