temp

standard_conforming_strings = off
backslash_quote = off

test=# insert into hoge(hoge) values('\'');
ERROR:  unsafe use of \' in a string literal

test=# insert into hoge(hoge) values('\\');
WARNING:  nonstandard use of \\ in a string literal
\が入る

test=# insert into hoge(hoge) values(E'\'');
ERROR:  unsafe use of \' in a string literal

test=# insert into hoge(hoge) values(E'\\');
\が入る

standard_conforming_strings = off
backslash_quote = on

test=# insert into hoge(hoge) values('\'');
WARNING:  nonstandard use of \' in a string literal
'が入る

test=# insert into hoge(hoge) values('\\');
WARNING:  nonstandard use of \\ in a string literal
\が入る

test=# insert into hoge(hoge) values(E'\'');
'が入る

test=# insert into hoge(hoge) values(E'\\');
\が入る

standard_conforming_strings = on
backslash_quote = off

test=# insert into hoge(hoge) values('\'');
'を閉じてないのでNG

test=# insert into hoge(hoge) values('\\');
\\が入る

test=# insert into hoge(hoge) values(E'\'');
ERROR:  unsafe use of \' in a string literal

test=# insert into hoge(hoge) values(E'\\');
\が入る

standard_conforming_strings = on
backslash_quote = on

test=# insert into hoge(hoge) values('\'');
'を閉じてないのでNG

test=# insert into hoge(hoge) values('\\');
\\が入る

test=# insert into hoge(hoge) values(E'\'');
'が入る

test=# insert into hoge(hoge) values(E'\\');
\が入る

backslash_quote = off
standard_conforming_strings = off

===
test=# insert into hoge(hoge) values('''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values('\'');
ERROR:  unsafe use of \' in a string literal
LINE 1: insert into hoge(hoge) values('\'');
                                      
HINT:  Use '' to write quotes in strings. \' is insecure in client-only encodings.
===
test=# insert into hoge(hoge) values('\\');
WARNING:  nonstandard use of \\ in a string literal
LINE 1: insert into hoge(hoge) values('\\');
                                      
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)
===
test=# insert into hoge(hoge) values(E'''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\'');
ERROR:  unsafe use of \' in a string literal
LINE 1: insert into hoge(hoge) values(E'\'');
                                      
HINT:  Use '' to write quotes in strings. \' is insecure in client-only encodings.
===
test=# insert into hoge(hoge) values(E'\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)

backslash_quote = off
standard_conforming_strings = on

===
test=# insert into hoge(hoge) values('''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
insert into hoge(hoge) values('\'');
'を閉じてないのでNG
===
test=# insert into hoge(hoge) values('\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \\
(1 row)
===
test=# insert into hoge(hoge) values(E'''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\'');
ERROR:  unsafe use of \' in a string literal
LINE 1: insert into hoge(hoge) values(E'\'');
                                      
HINT:  Use '' to write quotes in strings. \' is insecure in client-only encodings.
===
test=# insert into hoge(hoge) values(E'\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)

backslash_quote = on
standard_conforming_strings = off

===
test=# insert into hoge(hoge) values('''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values('\'');
WARNING:  nonstandard use of \' in a string literal
LINE 1: insert into hoge(hoge) values('\'');
                                      ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values('\\');
WARNING:  nonstandard use of \\ in a string literal
LINE 1: insert into hoge(hoge) values('\\');
                                      ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)
===
test=# insert into hoge(hoge) values(E'''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\'');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)

backslash_quote = on
standard_conforming_strings = on

===
test=# insert into hoge(hoge) values('''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values('\'');
'を閉じてないのでNG
===
test=# insert into hoge(hoge) values('\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \\
(1 row)
===
test=# insert into hoge(hoge) values(E'''');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\'');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 '
(1 row)
===
test=# insert into hoge(hoge) values(E'\\');
INSERT 0 1
test=# select * from hoge;
 hoge
------
 \
(1 row)