|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.131 2005/01/22 22:31:52 momjian Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.132 2005/01/2223:22:19 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -2179,11 +2179,11 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:content);</userinput> |
2179 | 2179 | they don't cause a syntax error when the second line is processed. This |
2180 | 2180 | could be done with the program <command>sed</command>: |
2181 | 2181 | <programlisting> |
2182 | | -testdb=> <userinput>\set content '\'' `sed -e "s/'/\\\\\\'/g"< my_file.txt` '\''</userinput> |
| 2182 | +testdb=> <userinput>\set content '\'' `sed -e "s/'/\\\\\\'/g"< my_file.txt` '\''</userinput> |
2183 | 2183 | </programlisting> |
2184 | 2184 | Observe the correct number of backslashes (6)! It works |
2185 | 2185 | this way: After <application>psql</application> has parsed this |
2186 | | - line, it passes <literal>sed -e "s/'/\\\'/g"< my_file.txt</literal> |
| 2186 | + line, it passes <literal>sed -e "s/'/\\\'/g"< my_file.txt</literal> |
2187 | 2187 | to the shell. The shell will do its own thing inside the double |
2188 | 2188 | quotes and execute <command>sed</command> with the arguments |
2189 | 2189 | <literal>-e</literal> and <literal>s/'/\\'/g</literal>. When |
@@ -2243,8 +2243,8 @@ testdb=> <userinput>\set content '\'' `sed -e "s/'/\\\\\\'/g" < my_file.txt` |
2243 | 2243 | The full host name (with domain name) of the database server, |
2244 | 2244 | or <literal>[local]</literal> if the connection is over a Unix |
2245 | 2245 | domain socket, or |
2246 | | - <literal>[local:<replaceable>/dir/name</replaceable>]</literal |
2247 | | ->,if the Unix domain socket is not at the compiled in default |
| 2246 | + <literal>[local:<replaceable>/dir/name</replaceable>]</literal>, |
| 2247 | + if the Unix domain socket is not at the compiled in default |
2248 | 2248 | location. |
2249 | 2249 | </para> |
2250 | 2250 | </listitem> |
@@ -2632,8 +2632,8 @@ Field separator is "oo". |
2632 | 2632 | input. Notice the changing prompt: |
2633 | 2633 | <programlisting> |
2634 | 2634 | testdb=> <userinput>CREATE TABLE my_table (</userinput> |
2635 | | -testdb(> <userinput> first integer not null default 0,</userinput> |
2636 | | -testdb(> <userinput> second text)</userinput> |
| 2635 | +testdb(> <userinput> first integer not null default 0,</userinput> |
| 2636 | +testdb(> <userinput> second text)</userinput> |
2637 | 2637 | testdb-> <userinput>;</userinput> |
2638 | 2638 | CREATE TABLE |
2639 | 2639 | </programlisting> |
|