Postgres Pro
Downloads
Home   >   mailing lists

Re: How to escape apostrophes when apostrophes already used to escape something else - Mailing list pgsql-general

From Sam Mason
Subject Re: How to escape apostrophes when apostrophes already used to escape something else
Date
Msg-id 20100205144534.GE5407@samason.me.uk
Whole thread Raw
In response to How to escape apostrophes when apostrophes already used to escape something else  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
List pgsql-general
Tree view 
On Fri, Feb 05, 2010 at 10:13:21AM +0100, Stefan Schwarzer wrote:
> probably not too complicated, but although googling my way through
> many pages, I don't find the solution.
>
> I have a query which uses already an apostrophe to escape something
> else:

Not sure if "dollar quoting" may be easier for you here.  Have a look
at:

 http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: manugarciac
Date:
Subject: Idle in Transaction
Next
From: RW
Date:
Subject: Re: Idle in Transaction