Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group