Add E'' syntax so eventually normal strings can treat backslashes

Bruce Momjian <bruce@momjian.us>

Commit: bb3cce4ec9cc157a8dfc80b5b1770c2beac0a57e
Author: Bruce Momjian <bruce@momjian.us>
Date: 2005-06-26T03:04:37Z
Releases: 8.1.0
Add E'' syntax so eventually normal strings can treat backslashes
literally.

Add GUC variables:

        "escape_string_warning" - warn about backslashes in non-E strings
        "escape_string_syntax" - supports E'' syntax?
        "standard_compliant_strings" - treats backslashes literally in ''

Update code to use E'' when escapes are used.

Files

PathChange+/−
contrib/tsearch2/expected/tsearch2.out modified +15 −15
contrib/tsearch2/sql/tsearch2.sql modified +15 −15
doc/src/sgml/runtime.sgml modified +56 −1
doc/src/sgml/syntax.sgml modified +19 −4
src/backend/parser/scan.l modified +49 −2
src/backend/utils/misc/guc.c modified +33 −2
src/backend/utils/misc/postgresql.conf.sample modified +1 −0
src/bin/initdb/initdb.c modified +5 −3
src/bin/pg_dump/pg_dumpall.c modified +2 −2
src/bin/psql/describe.c modified +2 −2
src/include/catalog/pg_proc.h modified +5 −5
src/include/utils/guc.h modified +2 −1
src/test/regress/expected/arrays.out modified +1 −1
src/test/regress/expected/copy2.out modified +4 −4
src/test/regress/expected/int8.out modified +1 −1
src/test/regress/expected/numeric.out modified +1 −1
src/test/regress/expected/rowtypes.out modified +1 −1
src/test/regress/expected/timestamp.out modified +2 −2
src/test/regress/expected/timestamptz.out modified +2 −2
src/test/regress/expected/type_sanity.out modified +1 −1
src/test/regress/input/copy.source modified +6 −6
src/test/regress/output/copy.source modified +6 −6
src/test/regress/sql/arrays.sql modified +1 −1
src/test/regress/sql/copy2.sql modified +4 −4
src/test/regress/sql/int8.sql modified +1 −1
src/test/regress/sql/numeric.sql modified +1 −1
src/test/regress/sql/rowtypes.sql modified +1 −1
src/test/regress/sql/timestamp.sql modified +2 −2
src/test/regress/sql/timestamptz.sql modified +2 −2
src/test/regress/sql/type_sanity.sql modified +1 −1