escape

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: escape
Date: 2010-06-26 21:21:59
Message-ID: 20100626232159.6bb4c68a@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

debian sid
pg 8.4.4-1
===============
Hi list,

I read the docs about escaping, but I can't find any other manner to escape
than a backslash or to double the single quote:
SELECT metaphone('O\'CONNOR') or SELECT metaphone('O''CONNOR')

The doc's talking about E, but SELECT metaphone(E'O'CONNOR') fail.

standard_conforming_strings = off is commented out, so I guess it is off
by defaut.

Is there another way to escape characters that migh trigger an error?

JY
--
Shit Happens.

Responses

  • Re: escape at 2010-06-27 12:08:05 from Jasen Betts

Browse pgsql-novice by date

  From Date Subject
Next Message Mag Gam 2010-06-26 21:55:02 setting up a table relationship
Previous Message Jean-Yves F. Barbier 2010-06-25 16:40:01 Re: Disaster Database recovery