Re: [INTERFACES] escaping characters ... - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] escaping characters ...
Date
Msg-id 14678.947022205@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] escaping characters ...  (Michael Meskes <meskes@postgresql.org>)
List pgsql-interfaces
Michael Meskes <meskes@postgreSQL.org> writes:
> On Tue, Jan 04, 2000 at 01:12:58PM -0500, Tom Lane wrote:
>> When generating quoted strings for use in SQL commands, you should
>> prefix single-quote (') and backslash (\) characters with a backslash.

> Isn't the correct way to quote a single-quote with yet another single-quote?

Yeah, doubled '' works too (but only in SQL literals, not in COPY data).
Take your pick...
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] escaping characters ...
Next
From: "Joe Shevland"
Date:
Subject: Re: [INTERFACES] escaping characters ...