LispWorks now sets the PostgreSQL session variable
standard_conforming_strings
to
on
in order 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.
LispWorks Release Notes and Installation Guide - 23 Dec 2011