My solution was to set standard_conforming_strings = on in postgresql.conf.
Bill
dario@libero.it wrote:
Hello,
How can I quote a string *exactly* as it is? I tried using
quote_literal() but it doesn't return what I need in some cases.
E.g.
If my
string is: ss\\\ss
And I do:
select
dario.ber wrote:
> How can I quote a string *exactly* as it is? I tried using
> quote_literal() but it doesn't return what I need in some cases.
>
> E.g.
>
> If my
> string is: ss\\\ss
>
> And I do:
>
> select quote_literal('ss\\\ss');
>
> I get:
>
>
> E'ss\\ss' <-- My string now has E''
Thanks a lot for replies! Dollar quote is what I needed, but I could find it
in!
Dario
>Messaggio originale
>Da: mmonc...@gmail.com
>Data:
02/12/2009 14.15
>A: "dario@libero.it"
>Cc:
>Ogg: Re: [GENERAL] quote string exactly as it is
>
>On
On Wed, Dec 2, 2009 at 7:10 AM, dario@libero.it wrote:
> Hello,
>
> How can I quote a string *exactly* as it is? I tried using
> quote_literal() but it doesn't return what I need in some cases.
>
> E.g.
>
> If my
> string is: ss\\\ss
dollar quote it:
select $abc$ss\\\ss$abc$;
merlin
--
Se
On Wed, Dec 2, 2009 at 12:10 PM, dario@libero.it wrote:
> Hello,
>
> How can I quote a string *exactly* as it is? I tried using
> quote_literal() but it doesn't return what I need in some cases.
>
> E.g.
>
> If my
> string is: ss\\\ss
>
> And I do:
>
> select quote_literal('ss\\\ss');
>
> I ge
Hello,
How can I quote a string *exactly* as it is? I tried using
quote_literal() but it doesn't return what I need in some cases.
E.g.
If my
string is: ss\\\ss
And I do:
select quote_literal('ss\\\ss');
I get:
E'ss\\ss' <-- My string now has E'' added and one backslash has been removed!
