escape - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject escape
Date
Msg-id 20100626232159.6bb4c68a@anubis.defcon1
Whole thread Raw
List 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.

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Disaster Database recovery
Next
From: Mag Gam
Date:
Subject: setting up a table relationship