|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.58 2001/09/03 12:57:50 petere Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.59 2001/09/11 05:11:59 ishii Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -1961,7 +1961,7 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:content);</userinput> |
1961 | 1961 | they don't cause a syntax error when the third line is processed. This |
1962 | 1962 | could be done with the program <application>sed</application>: |
1963 | 1963 | <programlisting> |
1964 | | -testdb=> <userinput>\set content `sed -e "s/'/\\\\\\'/g" < my_file.txt`</userinput> |
| 1964 | +testdb=> <userinput>\set content'\''`sed -e "s/'/\\\\\\'/g" < my_file.txt` '\''</userinput> |
1965 | 1965 | </programlisting> |
1966 | 1966 | Observe the correct number of backslashes (6)! You can resolve it this way: After |
1967 | 1967 | <application>psql</application> has parsed this line, it passes |
|