Horton

Escape Quotes

Keith Gray <keith@heart.com.au>

View thread View on postgr.es
From: Keith Gray <keith@heart.com.au>
To: PostgreSQL <pgsql-sql@postgresql.org>
Date: 2001-05-11T01:11:46Z
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