]> granicus.if.org Git - postgresql/blob - doc/src/sgml/reference.sgml
Add pg_basebackup tool for streaming base backups
[postgresql] / doc / src / sgml / reference.sgml
1 <!-- doc/src/sgml/reference.sgml -->
2
3 <part id="reference">
4  <title>Reference</title>
5
6  <partintro>
7   <para>
8    The entries in this Reference are meant to provide in reasonable
9    length an authoritative, complete, and formal summary about their
10    respective subjects.  More information about the use of
11    <productname>PostgreSQL</productname>, in narrative, tutorial, or
12    example form, can be found in other parts of this book.  See the
13    cross-references listed on each reference page.
14   </para>
15
16   <para>
17    The reference entries are also available as traditional
18    <quote>man</quote> pages.
19   </para>
20  </partintro>
21
22  <reference id="sql-commands">
23   <title>SQL Commands</title>
24
25   <partintro>
26    <para>
27     This part contains reference information for the
28     <acronym>SQL</acronym> commands supported by
29     <productname>PostgreSQL</productname>.  By <quote>SQL</quote> the
30     language in general is meant; information about the standards
31     conformance and compatibility of each command can be found on the
32     respective reference page.
33    </para>
34   </partintro>
35
36    &abort;
37    &alterAggregate;
38    &alterConversion;
39    &alterDatabase;
40    &alterDefaultPrivileges;
41    &alterDomain;
42    &alterForeignDataWrapper;
43    &alterForeignTable;
44    &alterFunction;
45    &alterGroup;
46    &alterIndex;
47    &alterLanguage;
48    &alterLargeObject;
49    &alterOperator;
50    &alterOperatorClass;
51    &alterOperatorFamily;
52    &alterRole;
53    &alterSchema;
54    &alterSequence;
55    &alterServer;
56    &alterTable;
57    &alterTableSpace;
58    &alterTSConfig;
59    &alterTSDictionary;
60    &alterTSParser;
61    &alterTSTemplate;
62    &alterTrigger;
63    &alterType;
64    &alterUser;
65    &alterUserMapping;
66    &alterView;
67    &analyze;
68    &begin;
69    &checkpoint;
70    &close;
71    &cluster;
72    &commentOn;
73    &commit;
74    &commitPrepared;
75    &copyTable;
76    &createAggregate;
77    &createCast;
78    &createConversion;
79    &createDatabase;
80    &createDomain;
81    &createForeignDataWrapper;
82    &createForeignTable;
83    &createFunction;
84    &createGroup;
85    &createIndex;
86    &createLanguage;
87    &createOperator;
88    &createOperatorClass;
89    &createOperatorFamily;
90    &createRole;
91    &createRule;
92    &createSchema;
93    &createSequence;
94    &createServer;
95    &createTable;
96    &createTableAs;
97    &createTableSpace;
98    &createTSConfig;
99    &createTSDictionary;
100    &createTSParser;
101    &createTSTemplate;
102    &createTrigger;
103    &createType;
104    &createUser;
105    &createUserMapping;
106    &createView;
107    &deallocate;
108    &declare;
109    &delete;
110    &discard;
111    &do;
112    &dropAggregate;
113    &dropCast;
114    &dropConversion;
115    &dropDatabase;
116    &dropDomain;
117    &dropForeignDataWrapper;
118    &dropForeignTable;
119    &dropFunction;
120    &dropGroup;
121    &dropIndex;
122    &dropLanguage;
123    &dropOperator;
124    &dropOperatorClass;
125    &dropOperatorFamily;
126    &dropOwned;
127    &dropRole;
128    &dropRule;
129    &dropSchema;
130    &dropSequence;
131    &dropServer;
132    &dropTable;
133    &dropTableSpace;
134    &dropTSConfig;
135    &dropTSDictionary;
136    &dropTSParser;
137    &dropTSTemplate;
138    &dropTrigger;
139    &dropType;
140    &dropUser;
141    &dropUserMapping;
142    &dropView;
143    &end;
144    &execute;
145    &explain;
146    &fetch;
147    &grant;
148    &insert;
149    &listen;
150    &load;
151    &lock;
152    &move;
153    &notify;
154    &prepare;
155    &prepareTransaction;
156    &reassignOwned;
157    &reindex;
158    &releaseSavepoint;
159    &reset;
160    &revoke;
161    &rollback;
162    &rollbackPrepared;
163    &rollbackTo;
164    &savepoint;
165    &securityLabel;
166    &select;
167    &selectInto;
168    &set;
169    &setConstraints;
170    &setRole;
171    &setSessionAuth;
172    &setTransaction;
173    &show;
174    &startTransaction;
175    &truncate;
176    &unlisten;
177    &update;
178    &vacuum;
179    &values;
180
181  </reference>
182
183  <reference id="reference-client">
184   <title>PostgreSQL Client Applications</title>
185
186   <partintro>
187    <para>
188     This part contains reference information for
189     <productname>PostgreSQL</productname> client applications and
190     utilities.  Not all of these commands are of general utility; some
191     might require special privileges.  The common feature of these
192     applications is that they can be run on any host, independent of
193     where the database server resides.
194    </para>
195   </partintro>
196
197    &clusterdb;
198    &createdb;
199    &createlang;
200    &createuser;
201    &dropdb;
202    &droplang;
203    &dropuser;
204    &ecpgRef;
205    &pgBasebackup;
206    &pgConfig;
207    &pgDump;
208    &pgDumpall;
209    &pgRestore;
210    &psqlRef;
211    &reindexdb;
212    &vacuumdb;
213
214  </reference>
215
216  <reference id="reference-server">
217   <title>PostgreSQL Server Applications</title>
218
219   <partintro>
220    <para>
221     This part contains reference information for
222     <productname>PostgreSQL</productname> server applications and
223     support utilities.  These commands can only be run usefully on the
224     host where the database server resides.  Other utility programs
225     are listed in <xref linkend="reference-client">.
226    </para>
227   </partintro>
228
229    &initdb;
230    &pgControldata;
231    &pgCtl;
232    &pgResetxlog;
233    &postgres;
234    &postmaster;
235
236  </reference>
237
238 </part>