Postgres Pro
Downloads
Home   >   mailing lists

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

From Grzegorz Jaśkiewicz
Subject Re: How to escape apostrophes when apostrophes already used to escape something else
Date
Msg-id 2f4958ff1002050121r64eee3b7qa4f50e84a6c26e70@mail.gmail.com
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 
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.

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: How to escape apostrophes when apostrophes already used to escape something else
Next
From: dipti shah
Date:
Subject: Re: Setting permissions to access schema and language