Wiki / Configuration Parameters

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.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

on

category

Version and Platform Compatibility / Previous PostgreSQL Versions

context

user

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

standard_conforming_strings

short desc

Causes '...' strings to treat backslashes literally.

source

pg-settings-source-snapshot

unit

Unknown

vartype

bool