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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
