Contents

\pset standard_conforming_strings off
SELECT '\'';
SELECT '''';
SELECT 'A\nBC';
SELECT E'A\nBC';
SELECT U&'d\0061t\+000061'; --error
\pset standard_conforming_strings on
SELECT '\''; -- error
SELECT '''';
SELECT 'A\nBC';
SELECT E'A\nBC';

\pset server_encoding SQL_ASCII
# unicode ident
SELECT * FROM U&"d\0061t\+000061";
# unicode literal
SELECT E'd\u0061t\U00000061';
SELECT U&'d\0061t\+000061';
SELECT U&'d!0061t!+000061' UESCAPE '!';
SELECT E'\u3042\u3044\u3046\u3048\u304a'; -- error
SELECT U&'\3042\3044\3046\3048\304a'; -- error

\pset server_encoding UTF8
# unicode ident
SELECT * FROM U&"d\0061t\+000061";
# unicode literal
SELECT E'd\u0061t\U00000061';
SELECT U&'d\0061t\+000061';
SELECT U&'d!0061t!+000061' UESCAPE '!';
SELECT E'\u3042\u3044\u3046\u3048\u304a';
SELECT U&'\3042\3044\3046\3048\304a';
# surrogate pair
SELECT E'\ud800\udc00';
SELECT U&'\d800\dc00';

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
prestogres-0.4.8	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.7	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.6	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.5	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.4	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.3	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.2	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.1	pgpool2/test/parser/input/scanner.sql
prestogres-0.4.0	pgpool2/test/parser/input/scanner.sql
prestogres-0.3.0	pgpool2/test/parser/input/scanner.sql
prestogres-0.2.0	pgpool2/test/parser/input/scanner.sql
prestogres-0.1.0	pgpool2/test/parser/input/scanner.sql