598
598
determined at compile time.
599
599
Since the database server uses the same default, you will not have
600
600
to specify the port in most cases. The default user name is your
601
- Unix user name, as is the default database name. Note that you cannot
601
+ operating-system user name, as is the default database name.
602
+ Note that you cannot
602
603
just connect to any database under any user name. Your database
603
604
administrator should have informed you about your access rights.
604
605
</para>
@@ -1628,14 +1629,14 @@ Tue Oct 26 21:40:57 CEST 1999
1628
1629
1629
1630
1630
1631
<varlistentry>
1631
- <term><literal>\g</literal> [{ <replaceable class="parameter">filename</replaceable>| <literal>|< /literal><replaceable class="parameter">command</replaceable> } ] </term>
1632
-
1632
+ <term><literal>\g [ <replaceable class="parameter">filename</replaceable>]< /literal></term>
1633
+ <term><literal>\g [ |<replaceable class="parameter">command</replaceable> ]</literal></term>
1633
1634
<listitem>
1634
1635
<para>
1635
- Sends the current query input buffer to the server and
1636
+ Sends the current query input buffer to the server, and
1636
1637
optionally stores the query's output in <replaceable
1637
1638
class="parameter">filename</replaceable> or pipes the output
1638
- into a separate Unix shellexecuting <replaceable
1639
+ to the shellcommand <replaceable
1639
1640
class="parameter">command</replaceable>. The file or command is
1640
1641
written to only if the query successfully returns zero or more tuples,
1641
1642
not if the query fails or is a non-data-returning SQL command.
@@ -1649,7 +1650,7 @@ Tue Oct 26 21:40:57 CEST 1999
1649
1650
</varlistentry>
1650
1651
1651
1652
<varlistentry>
1652
- <term><literal>\gset</literal> [ <replaceable class="parameter">prefix</replaceable> ]</term>
1653
+ <term><literal>\gset [ <replaceable class="parameter">prefix</replaceable> ]</literal> </term>
1653
1654
1654
1655
<listitem>
1655
1656
<para>
@@ -1713,7 +1714,7 @@ hello 10
1713
1714
1714
1715
1715
1716
<varlistentry>
1716
- <term><literal>\H</literal></term>
1717
+ <term><literal>\H</literal> or <literal>\html</literal> </term>
1717
1718
<listitem>
1718
1719
<para>
1719
1720
Turns on <acronym>HTML</acronym> query output format. If the
@@ -1727,7 +1728,7 @@ hello 10
1727
1728
1728
1729
1729
1730
<varlistentry>
1730
- <term><literal>\i < replaceable class="parameter">filename</replaceable></literal ></term>
1731
+ <term><literal>\i</literal> or <literal>\include</literal> < replaceable class="parameter">filename</replaceable></term>
1731
1732
<listitem>
1732
1733
<para>
1733
1734
Reads input from the file <replaceable
@@ -1746,7 +1747,7 @@ hello 10
1746
1747
1747
1748
1748
1749
<varlistentry>
1749
- <term><literal>\ir < replaceable class="parameter">filename</replaceable></literal ></term>
1750
+ <term><literal>\ir</literal> or <literal>\include_relative</literal> < replaceable class="parameter">filename</replaceable></term>
1750
1751
<listitem>
1751
1752
<para>
1752
1753
The <literal>\ir</> command is similar to <literal>\i</>, but resolves
@@ -1862,15 +1863,15 @@ lo_import 152801
1862
1863
1863
1864
1864
1865
<varlistentry>
1865
- <term><literal>\o</literal>[ { <replaceable class="parameter">filename</replaceable>| <literal>|< /literal><replaceable class="parameter">command</replaceable>} ] </term>
1866
-
1866
+ <term><literal>\o</literal>or <literal>\out [ <replaceable class="parameter">filename</replaceable>]< /literal></term>
1867
+ <term><literal>\o</literal> or <literal>\out [ |<replaceable class="parameter">command</replaceable> ]</literal></term>
1867
1868
<listitem>
1868
1869
<para>
1869
- Saves future query results to the file <replaceable
1870
- class="parameter">filename</replaceable> orpipes future results
1871
- into a separate Unix shellto execute <replaceable
1872
- class="parameter">command</replaceable>. If noarguments are
1873
- specified, the query outputwill be reset to the standard output.
1870
+ Arranges to save future query results to the file <replaceable
1871
+ class="parameter">filename</replaceable> orpipe future results
1872
+ to the shellcommand <replaceable
1873
+ class="parameter">command</replaceable>. If noargument is
1874
+ specified, the query outputis reset to the standard output.
1874
1875
</para>
1875
1876
1876
1877
<para><quote>Query results</quote> includes all tables, command
@@ -1891,7 +1892,7 @@ lo_import 152801
1891
1892
1892
1893
1893
1894
<varlistentry>
1894
- <term><literal>\p</literal></term>
1895
+ <term><literal>\p</literal> or <literal>\print</literal> </term>
1895
1896
<listitem>
1896
1897
<para>
1897
1898
Print the current query buffer to the standard output.
@@ -2323,7 +2324,7 @@ lo_import 152801
2323
2324
2324
2325
2325
2326
<varlistentry>
2326
- <term><literal>\r</literal></term>
2327
+ <term><literal>\r</literal> or <literal>\reset</literal> </term>
2327
2328
<listitem>
2328
2329
<para>
2329
2330
Resets (clears) the query buffer.
@@ -2483,12 +2484,12 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput>
2483
2484
2484
2485
2485
2486
<varlistentry>
2486
- <term><literal>\w</literal> <replaceable class="parameter">filename</replaceable></term>
2487
- <term><literal>\w</literal> <literal>|</><replaceable class="parameter">command</replaceable></term>
2487
+ <term><literal>\w</literal>or <literal>\write</literal> <replaceable class="parameter">filename</replaceable></term>
2488
+ <term><literal>\w</literal>or <literal>\write</literal> <literal>|</><replaceable class="parameter">command</replaceable></term>
2488
2489
<listitem>
2489
2490
<para>
2490
2491
Outputs the current query buffer to the file <replaceable
2491
- class="parameter">filename</replaceable> or pipes it to theUnix
2492
+ class="parameter">filename</replaceable> or pipes it to theshell
2492
2493
command <replaceable class="parameter">command</replaceable>.
2493
2494
</para>
2494
2495
</listitem>
@@ -2541,7 +2542,7 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput>
2541
2542
<term><literal>\! [ <replaceable class="parameter">command</replaceable> ]</literal></term>
2542
2543
<listitem>
2543
2544
<para>
2544
- Escapes to a separateUnix shell or executes theUnix command
2545
+ Escapes to a separate shell or executes theshell command
2545
2546
<replaceable class="parameter">command</replaceable>. The
2546
2547
arguments are not further interpreted; the shell will see them
2547
2548
as-is. In particular, the variable substitution rules and