This is a real pain. What I do is have a "cleanString" method that
I pass everything through when constructing SQL statements
that changes all '\' to '\\' and all seems to work just fine.
Also note that pg_dump has a bug in this area that I am unable
to get attention from anyone. In my setting, if I pass "\net" in
the actual SQL it turns into "\\net" but when read as part of a select,
it is "\net" as expected. However, pg_dump does not double-up
the backslash, so it is unusable to psql.
Anyone listening?
----- Original Message -----
From: Joel Fischer <joelf@min.ascend.com>
To: <pgsql-sql@postgreSQL.org>
Sent: Monday, January 11, 1999 4:05 PM
Subject: [SQL] storing strings with embedded '\'
>Hello, interested in storing strings with embedded '\' characters? Using
\\
>appears to store \\. Suggestions?
>
>Joel Fischer
>Ascend COmmunications
>