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