copy from ignores \,

Read the COPY manual page --- backslashes are special and have to be
doubled to be treated as literal.

---------------------------------------------------------------------------

Bauhofer Mario wrote:

Hi,

i tried to copy a german text file into a table "imp" using copy from.

SET client_encoding TO LATIN1; -- german umlaute

Copy imp from 'filepath/filename.txt' delimiter as ',' Null as '\n';

As you can see the "text" contains commas escaped by a backslash.

But copy from ignores the \, an treat them as a separator

Is this correct ?

Do I miss something.

Thx for the help!

Create table imp(

Id smallint,

numberx int4,

Text varchar(255)

)

...

458,9009009,sometext1\,sometext2\,sometext3

..

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073