escape_string_warning

• 17
• 16
• 15
• 14
• 13
• 12
• 11
• 10
• 9.6
• 9.5
• 9.4
• 9.3
• 9.2
• 9.1
• 9.0
• 8.4
• 8.3
• 8.2

escape_string_warning 的基本用法示例

postgres=# SET standard_conforming_strings TO off;
SET

postgres=# SELECT 'hello \\world';
WARNING:  nonstandard use of \\ in a string literal
LINE 1: SELECT 'hello \\world';
               ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
   ?column?   
--------------
 hello \world
(1 row)

postgres=# SET escape_string_warning TO off;
SET
postgres=# SELECT 'hello \\world';
   ?column?   
--------------
 hello \world
(1 row)

• PostgreSQL 文档： escape_string_warning