LispWorks sets the PostgreSQL session variable
standard_conforming_strings
to
on
to match the escaping that Common SQL uses. Note that this variable is only available in PostgreSQL 8.2 and later, so escaping will not work correctly in older versions of PostgreSQL.
LispWorks User Guide and Reference Manual - 21 Dec 2011