Re: [GENERAL] Copy command to load data into a PostgreSQL DB

2006-11-17 Thread Reece Hart
On Fri, 2006-11-17 at 15:46 -0500, Wm.A.Stafford wrote: > If we use '\x05' as suggested by the > Fastreader User guide. PostgreSQL complains "ERROR: COPY delimiter > must be a single character". > > Any help or suggestions would be appreciated. \x05, aka control-e, ctl-e, ^e, C-e, etc, is

Re: [GENERAL] Copy command to load data into a PostgreSQL DB

2006-11-17 Thread Dimitri Fontaine
Hi, Le vendredi 17 novembre 2006 21:46, Wm.A.Stafford a écrit : > We can not figure out > how to specify a non-printing character for the delimiter in the > PostgreSQL copy command. If we use '\x05' as suggested by the > Fastreader User guide. PostgreSQL complains "ERROR: COPY delimiter > must