connected

SET standard_conforming_strings=on
Executing: SELECT 'foo', ?::text with param: param'quote
Result set:
foo	param'quote
Executing: SELECT 'foo', ?::text with param: param\backslash
Result set:
foo	param\backslash
Executing: SELECT 'foo', ?::text with param: ends with backslash\
Result set:
foo	ends with backslash\
Executing: SELECT 'doubled '' quotes', ?::text with param: param
Result set:
doubled ' quotes	param
Executing: SELECT E'escaped quote\' here', ?::text with param: param
Result set:
escaped quote' here	param
Executing: SELECT $$dollar quoted string$$, ?::text with param: param
Result set:
dollar quoted string	param
Executing: SELECT $xx$complex $dollar quotes$xx$, ?::text with param: param
Result set:
complex $dollar quotes	param
Executing: SELECT $dollar$morecomplex $dollar quotes$dollar$, ?::text with param: param
Result set:
morecomplex $dollar quotes	param
Executing: SELECT ?::text, '1' a$1 with param: $ in an identifier
Result set:
$ in an identifier	1
Executing: SELECT '1'::text a$$S1,?::text,$$2 $'s in an identifier$$::text with param: param
Result set:
1	param	2 $'s in an identifier

SET standard_conforming_strings=off
Executing: SELECT 'foo', ?::text with param: param'quote
Result set:
foo	param'quote
Executing: SELECT 'foo', ?::text with param: param\backslash
Result set:
foo	param\backslash
Executing: SELECT 'foo', ?::text with param: ends with backslash\
Result set:
foo	ends with backslash\
Executing: SELECT 'doubled '' quotes', ?::text with param: param
Result set:
doubled ' quotes	param
Executing: SELECT E'escaped quote\' here', ?::text with param: param
Result set:
escaped quote' here	param
Executing: SELECT $$dollar quoted string$$, ?::text with param: param
Result set:
dollar quoted string	param
Executing: SELECT $xx$complex $dollar quotes$xx$, ?::text with param: param
Result set:
complex $dollar quotes	param
Executing: SELECT $dollar$morecomplex $dollar quotes$dollar$, ?::text with param: param
Result set:
morecomplex $dollar quotes	param
Executing: SELECT 'escaped quote\' here', ?::text with param: param
Result set:
escaped quote' here	param
Executing: SELECT ?::text, '1' a$1 with param: $ in an identifier
Result set:
$ in an identifier	1
Executing: SELECT '1'::text a$$S1,?::text,$$2 $'s in an identifier$$::text with param: param
Result set:
1	param	2 $'s in an identifier
disconnecting
