Re: Escape Quotes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Keith Gray <keith(at)heart(dot)com(dot)au>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Escape Quotes
Date: 2001-05-11 02:34:03
Message-ID: 11049.989548443@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Keith Gray <keith(at)heart(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-11 02:38:51 Re: Escape Quotes
Previous Message Frank Bax 2001-05-11 01:53:01 Re: Order by email address by domain ?