Horton

Re: Escape Quotes

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Keith Gray <keith@heart.com.au>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Date: 2001-05-11T02:34:03Z
Lists: pgsql-sql 
Keith Gray <keith@heart.com.au> writes:
> Is it possible to get/configure PostgreSQL to handle <quote><quote>
> as <quote> within a dleimited string?

We already do.

regression=# select 'O''SHEA';
 ?column?
----------
 O'SHEA
(1 row)


			regards, tom lane