Re: escape single quote in INSERT command

mark carew <markcarew@bigpond.com>

From: "mark carew" <markcarew@bigpond.com>
To: pgsql-sql@postgresql.org
Date: 2002-11-22T21:50:35Z
Lists: pgsql-sql
Hi Hunter,

    From my xbase++ program suite, sqlcontext class.
                *
                cValue := strtran(cValue,['],[\'])
                 *
    Its called masquarading, simply replace the single quote with back_slash
+ single quote.

    Regards
    Mark Carew
    Brisbane Australia