Thanks for the info, I will correct my statements.
I have reported it, because syntax highlighting in pgAdmin 3 was able to show it even with single backslash and PostgreSQL returns it visually correct. Result: solved Von: Melvin Davidson [mailto:melvin6...@yahoo.com] Gesendet: Montag, 22. Mai 2017 21:39 An: mammoth.po...@gmx.us; pgadmin-support@postgresql.org Betreff: Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\' >When I have somewhere in text value single backslash char, then everything >behind this char will not be highlighted correct. <https://www.postgresql.org/docs/9.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES> That is because the Backslash is an ESCAPE character, so you must ESCAPE it and use two backslashes if you want it to be interpreted as a literal. Also, do not forget to enclose your strings in quotes! IE: SELECT 'a' || E'\\' || 'b' UNION ALL SELECT 'c' || E'\\' || 'd'; <https://www.postgresql.org/docs/9.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES> https://www.postgresql.org/docs/9.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES Melvin Davidson 🎸 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Das Bild wurde vom Absender entfernt. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com _____ From: "mammoth.po...@gmx.us" <mammoth.po...@gmx.us> To: pgadmin-support@postgresql.org Sent: Monday, May 22, 2017 3:17 PM Subject: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\' When I have somewhere in text value single backslash char, then everything behind this char will not be highlighted correct. Simple example 1: SELECT '\'; Simple example 2: -- Test 1 SELECT a || '\' || b UNION ALL -- Test 2 SELECT c || '\' || d; Screenshots of syntax highlighting: Single backslash: Dual backslash: pgAdmin 4 v1.5 Desktop Runtime Windows 10 x64 1511
