Re: [pgadmin-support] SQL syntax highlightning don't work for singlebackslash '\' - Mailing list pgadmin-support

From David G. Johnston
Subject Re: [pgadmin-support] SQL syntax highlightning don't work for singlebackslash '\'
Date
Msg-id CAKFQuwaJCCXA2v=Xc0i6BtCqYzm-5WbuTgB9heXZ6dMWJ_hv1w@mail.gmail.com
Whole thread Raw
In response to Re: [pgadmin-support] SQL syntax highlightning don't work forsingle backslash '\'  (Melvin Davidson <melvin6925@yahoo.com>)
List pgadmin-support
On Monday, May 22, 2017, Melvin Davidson <melvin6925@yahoo.com> wrote:
>Unless you omit the E prefix on the string literal, which the OP did.

Nope! That results in 'a//b' but the op wants 'a/b';
Hence the need to Escape.

PgAdmin is buggy if it doesn't know that there is no output difference between E'a\\b'  and 'a\b' and thus should disable string colors subsequent to either.

David J.

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgadmin-support] Popup message always that PgAdmin 3 starts
Next
From: Dave Page
Date:
Subject: Re: [pgadmin-support] Start of pgAdmin 1.5 takes longer then in 1.4