reference.sgml 4.52 KB
Newer Older
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
1
<!-- reference.sgml
2
$Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.23 2002/03/07 16:35:32 momjian Exp $
3

4
PostgreSQL Reference Manual
5
-->
6

7 8
<book id="reference">

9
 <title>PostgreSQL &version; Reference Manual</title>
10
 <bookinfo>
11
  <corpauthor>The PostgreSQL Global Development Group</corpauthor>
12
  &legal;
13
 </bookinfo>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
14

15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
 <preface id="reference-preface">
  <title>Preface</title>

  <para>
   The entries in this <citetitle>Reference Manual</citetitle> are
   meant to provide in reasonable length an authorative, complete, and
   formal summary about the respective subjects.  More information
   about the use of <productname>PostgreSQL</productname>, in
   narrative, tutorial, or example form, may be found in other parts
   of the <productname>PostgreSQL</productname> documentation set.
   See the cross-references listed on each reference page.
  </para>

  <para>
   The <citetitle>Reference Manual</citetitle> entries are also
   available as traditional <quote>man</quote> pages.
  </para>
 </preface>

34 35
 <reference id="sql-commands">
  <title>SQL Commands</title>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
36

37 38
  <partintro>
   <para>
39 40 41 42 43 44
    This part contains reference information for the
    <acronym>SQL</acronym> commands supported by
    <productname>PostgreSQL</productname>.  By <quote>SQL</quote> the
    language in general is meant; information about the standards
    conformance and compatibility of each command can be found on the
    respective reference page.
45 46 47 48
   </para>
  </partintro>

   &abort;
49
   &alterDatabase;
50 51 52
   &alterGroup;
   &alterTable;
   &alterUser;
53
   &analyze;
54
   &begin;
55
   &checkpoint;
56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
   &close;
   &cluster;
   &commentOn;
   &commit;
   &copyTable;
   &createAggregate;
   &createConstraint;
   &createDatabase;
   &createFunction;
   &createGroup;
   &createIndex;
   &createLanguage;
   &createOperator;
   &createRule;
   &createSequence;
   &createTable;
   &createTableAs;
   &createTrigger;
   &createType;
   &createUser;
   &createView;
   &declare;
   &delete;
   &dropAggregate;
   &dropDatabase;
   &dropFunction;
   &dropGroup;
   &dropIndex;
   &dropLanguage;
   &dropOperator;
   &dropRule;
   &dropSequence;
   &dropTable;
   &dropTrigger;
   &dropType
   &dropUser;
   &dropView;
   &end;
   &explain;
   &fetch;
   &grant;
   &insert;
   &listen;
   &load;
   &lock;
   &move;
   &notify;
   &reindex;
   &reset;
   &revoke;
   &rollback;
   &select;
   &selectInto;
   &set;
   &setConstraints;
111
   &setSessionAuth;
112 113 114 115 116 117
   &setTransaction;
   &show;
   &truncate;
   &unlisten;
   &update;
   &vacuum;
118
  
119
 </reference>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
120 121

<!--
122 123
Disable this chapter until we have more functions documented.
- thomas 1998-10-27
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
124

125 126
 <reference id="sql-functions">
  <title>SQL Functions</title>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
127

128 129 130 131
  <partintro>
   <para>
    This part provides reference information for the
    <acronym>SQL</acronym> functions supported by
132
    <productname>PostgreSQL</productname>.
133 134 135 136 137 138 139
   </para>

   &currentDate;
   &currentTime;
   &currentTimestamp;
   &currentUser;
 </reference>
140 141
-->

142
 <reference id="reference-client">
143
  <title>PostgreSQL Client Applications</title>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
144

145 146
  <partintro>
   <para>
147 148 149 150 151 152
    This part contains reference information for
    <productname>PostgreSQL</productname> client applications and
    utilities.  Not all of these commands are of general utility, some
    may require special privileges.  The common feature of these
    applications is that they can be run on any host, independent of
    where the database server resides.
153 154 155 156
   </para>
  </partintro>

   &createdb;
157
   &createlang;
158 159
   &createuser;
   &dropdb;
160
   &droplang;
161 162 163 164 165 166 167 168 169 170 171 172 173 174 175
   &dropuser;
   &ecpgRef;
   &pgAccess;
   &pgConfig;
   &pgDump;
   &pgDumpall;
   &pgRestore;
   &psqlRef;
   &pgTclSh;
   &pgTkSh;
   &vacuumdb;

 </reference>

 <reference id="reference-server">
176
  <title>PostgreSQL Server Applications</title>
177 178 179

  <partintro>
   <para>
180 181 182 183 184
    This part contains reference information for
    <productname>PostgreSQL</productname> server applications and
    support utilities.  These commands can only be run usefully on the
    host where the database server resides.  Other utility programs
    are listed in <xref linkend="reference-client">.
185 186 187 188 189 190 191 192 193 194 195 196
   </para>
  </partintro>

   &initdb;
   &initlocation;
   &ipcclean;
   &pgCtl;
   &pgPasswd;
   &postgres;
   &postmaster;

 </reference>
Thomas G. Lockhart's avatar
Thomas G. Lockhart committed
197

198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215
</book>

<!-- Keep this comment at the end of the file
Local variables:
mode:sgml
sgml-omittag:nil
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
sgml-parent-document:nil
sgml-default-dtd-file:"./reference.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:("/usr/lib/sgml/catalog")
sgml-local-ecat-files:nil
End:
-->