From 95dc7785b5f7b0e78dbd7d17ab53fb08d4108ad6 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Tue, 11 Sep 2001 05:11:59 +0000 Subject: [PATCH] Add single quote (example given here does not work) --- doc/src/sgml/ref/psql-ref.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index a495160eee..1ffa995f24 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,5 +1,5 @@ @@ -1961,7 +1961,7 @@ testdb=> INSERT INTO my_table VALUES (:content); they don't cause a syntax error when the third line is processed. This could be done with the program sed: -testdb=> \set content `sed -e "s/'/\\\\\\'/g" < my_file.txt` +testdb=> \set content '\'' `sed -e "s/'/\\\\\\'/g" < my_file.txt` '\'' Observe the correct number of backslashes (6)! You can resolve it this way: After psql has parsed this line, it passes -- 2.40.0