Horton

Re: sql standard: \' or ''

Gregory Wood <gwood@ewebengine.com>

View thread View on postgr.es
From: Gregory Wood <gwood@ewebengine.com>
To: CSN <cool_screen_name90001@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: 2004-05-05T22:10:28Z
Lists: pgsql-general 
CSN wrote:
> I heard that the sql standard for escaping quotes is
> '', and not \'. Is this true?
> 
> BTW, PHP's pg_escape_string returns \' and not ''.

Are you sure about that?

~# php -r "print pg_escape_string(\"I can't believe that quotes are 
escaped improperly\n\");"
I can''t believe that quotes are escaped improperly

Greg