Postgres Pro
Downloads
Home   >   mailing lists

Thread: copy from ignores \,

copy from ignores \,

From
"Bauhofer Mario"
Date:

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

……

 

Re: copy from ignores \,

From
Bruce Momjian
Date:
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