Re: How to escape apostrophes when apostrophes already used to escape something else

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to escape apostrophes when apostrophes already used to escape something else
Date: 2010-02-05 09:21:50
Message-ID: 2f4958ff1002050121r64eee3b7qa4f50e84a6c26e70@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

use $$
Or you can always use double single quotes, which is going to
translate into single one, ie : blah = 'foo '' bar';
will give you "foo ' bar" string.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dipti shah 2010-02-05 09:24:07 Re: Setting permissions to access schema and language
Previous Message Stefan Schwarzer 2010-02-05 09:13:21 How to escape apostrophes when apostrophes already used to escape something else