Escape Quotes

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Escape Quotes
Date: 2001-05-11 01:11:46
Message-ID: 3AFB3C52.315C48F0@heart.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

When using apostrophies the PostgreSQL string seems to like
an escape character as follows:

update client set code = 'O\'SHEA' where clientid = 2;

The ANSI-92 standard seems to suggest that this could/should
be handled by

<quote> ::= '
<quote symbol> ::= <quote><quote>

update client set code = 'O''SHEA' where clientid = 2;

Is it possible to get/configure PostgreSQL to handle <quote><quote>
as <quote> within a dleimited string?

Keith Gray

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2001-05-11 01:53:01 Re: Order by email address by domain ?
Previous Message Jeff Eckermann 2001-05-10 21:14:58 RE: Order by email address by domain ?