|
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>
|
|