Postgres Pro
Downloads
Home   >   mailing lists

Re: Escape Quotes - Mailing list pgsql-sql

From Tom Lane
Subject Re: Escape Quotes
Date
Msg-id 11049.989548443@sss.pgh.pa.us
Whole thread Raw
In response to Escape Quotes  (Keith Gray <keith@heart.com.au>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: Order by email address by domain ?
Next
From: Tom Lane
Date:
Subject: Re: Escape Quotes