PostgreSQL 9.1 选项standard_conforming_strings默认值为on

转载于 2014-02-19 16:01:00 发布 · 267 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/funix/blog/201227

文章标签：

#数据库

本文深入探讨了PostgreSQL9.1版本中standard_conforming_strings参数从默认off调整为on的变化，解释了此设置对字符串处理的影响，并提供了应用检查该参数以确定字符串如何被处理的方法，同时强调了使用escape strings语法的重要性。

为什么80%的码农都做不了架构师？>>>

PostgreSQL 9.1 选项standard_conforming_strings默认值为on，

[standard_conforming_strings (boolean)](http://www.postgresql.org/docs/9.3/static/runtime-config-compatible.html)

This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. Beginning in PostgreSQL 9.1, the default is on (prior releases defaulted to off). Applications can check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax (Section 4.1.2.2) should be used if an application desires backslashes to be treated as escape characters.

转载于:https://my.oschina.net/funix/blog/201227