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?
pgsql-interfaces by date
|Next:||From: Gunther Schadow||Date: 2002-06-05 21:54:58|
|Subject: Re: Escaping in COPY|
|Previous:||From: Andreas Kretzer||Date: 2002-06-05 06:03:15|
|Subject: Re: lo_import problem under Windows+BCB5|