Postgres Pro
Downloads
Home   >   mailing lists

Re: sql standard: \' or '' - Mailing list pgsql-general

From Gregory Wood
Subject Re: sql standard: \' or ''
Date
Msg-id 40996654.6030207@ewebengine.com
Whole thread Raw
In response to sql standard: \' or ''  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: snpe
Date:
Subject: Re: help me
Next
From: Jim Crate
Date:
Subject: Error linking libpq into client program