Escaping in COPY - Mailing list pgsql-interfaces

From Jeroen T. Vermeulen
Subject Escaping in COPY
Date
Msg-id 20020605181626.GB2113@bulletproof
Whole thread Raw
List pgsql-interfaces
How exactly does one escape tabs, newlines etc. when using COPY?  

I remember reading somewhere that one just prefixes a backslash to them
before passing them to PQputline().  And indeed, that seems to work fine.

But when the data is retrieved using another COPY and PQgetline(), I
find the tabs are escaped as '\t'.  I looked around the website and the
mailing list archives, but found nothing on this subject.

Can anyone tell me the definitive place to look?


TIA,

Jeroen




pgsql-interfaces by date:

Previous
From: Vicki Brown
Date:
Subject: Re: pg_dump.o(.text+0xf82): undefined reference to
Next
From: Gunther Schadow
Date:
Subject: Re: Escaping in COPY