postgres.sgml 7.2 KB
Newer Older
1
<!--
Tom Lane's avatar
Tom Lane committed
2
$PostgreSQL: pgsql/doc/src/sgml/postgres.sgml,v 1.70 2004/12/24 19:12:37 tgl Exp $
3 4
-->

5
<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook V4.2//EN" [
6

7 8 9 10
<!entity % version SYSTEM "version.sgml">
%version;
<!entity % filelist SYSTEM "filelist.sgml">
%filelist;
11

12
<!entity reference  SYSTEM "reference.sgml">
13

14
]>
15

16
<book id="postgres">
17 18
 <title>PostgreSQL &version; Documentation</title>

19
 <bookinfo>
20
  <corpauthor>The PostgreSQL Global Development Group</corpauthor>
21
  &legal;
22 23
 </bookinfo>

Peter Eisentraut's avatar
Peter Eisentraut committed
24
 &intro;
25 26 27 28 29 30

 <part id="tutorial">
  <title>Tutorial</title>

  <partintro>
   <para>
31
    Welcome to the <productname>PostgreSQL</productname> Tutorial.  The
32 33 34 35 36
    following few chapters are intended to give a simple introduction
    to <productname>PostgreSQL</productname>, relational database
    concepts, and the SQL language to those who are new to any one of
    these aspects.  We only assume some general knowledge about how to
    use computers.  No particular Unix or programming experience is
37
    required.  This part is mainly intended to give you some hands-on
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
    experience with important aspects of the
    <productname>PostgreSQL</productname> system.  It makes no attempt
    to be a complete or thorough treatment of the topics it covers.
   </para>

   <para>
    After you have worked through this tutorial you might want to move
    on to reading <xref linkend="sql"> to gain a more formal knowledge
    of the SQL language, or <xref linkend="client-interfaces"> for
    information about developing applications for
    <productname>PostgreSQL</productname>.  Those who set up and
    manage their own server should also read <xref linkend="admin">.
   </para>
  </partintro>

  &start;
  &query;
  &advanced;

 </part>

 <part id="sql">
  <title>The SQL Language</title>

  <partintro>
   <para>
    This part describes the use of the <acronym>SQL</acronym> language
    in <productname>PostgreSQL</productname>.  We start with
    describing the general syntax of <acronym>SQL</acronym>, then
    explain how to create the structures to hold data, how to populate
    the database, and how to query it.  The middle part lists the
    available data types and functions for use in
70
    <acronym>SQL</acronym> commands.  The rest treats several
71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
    aspects that are important for tuning a database for optimal
    performance.
   </para>

   <para>
    The information in this part is arranged so that a novice user can
    follow it start to end to gain a full understanding of the topics
    without having to refer forward too many times.  The chapters are
    intended to be self-contained, so that advanced users can read the
    chapters individually as they choose.  The information in this
    part is presented in a narrative fashion in topical units.
    Readers looking for a complete description of a particular command
    should look into <xref linkend="reference">.
   </para>

   <para>
Peter Eisentraut's avatar
Peter Eisentraut committed
87
    Readers of this part should know how to connect to a
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
    <productname>PostgreSQL</> database and issue
    <acronym>SQL</acronym> commands.  Readers that are unfamiliar with
    these issues are encouraged to read <xref linkend="tutorial">
    first.  <acronym>SQL</acronym> commands are typically entered
    using the <productname>PostgreSQL</> interactive terminal
    <application>psql</application>, but other programs that have
    similar functionality can be used as well.
   </para>
  </partintro>

  &syntax;
  &ddl;
  &dml;
  &queries;
  &datatype;
  &func;
  &typeconv;
  &indices;
  &mvcc;
  &perform;

 </part>

 <part id="admin">
  <title>Server Administration</title>

  <partintro>
   <para>
    This part covers topics that are of interest to a
    <productname>PostgreSQL</> database administrator.  This includes
    installation of the software, set up and configuration of the
    server, management of users and databases, and maintenance tasks.
Tom Lane's avatar
Tom Lane committed
120
    Anyone who runs a <productname>PostgreSQL</> server, even for
121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
    personal use, but especially in production, should be familiar
    with the topics covered in this part.
   </para>

   <para>
    The information in this part is arranged approximately in the
    order in which a new user should read it.  But the chapters are
    self-contained and can be read individually as desired.  The
    information in this part is presented in a narrative fashion in
    topical units.  Readers looking for a complete description of a
    particular command should look into <xref linkend="reference">.
   </para>

   <para>
    The first few chapters are written so that they can be understood
    without prerequisite knowledge, so that new users who need to set
    up their own server can begin their exploration with this part.
Tom Lane's avatar
Tom Lane committed
138 139
    The rest of this part is about tuning and management; that material
    assumes that the reader is familiar with the general use of
140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180
    the <productname>PostgreSQL</> database system.  Readers are
    encouraged to look at <xref linkend="tutorial"> and <xref
    linkend="sql"> for additional information.
   </para>
  </partintro>

  &installation;
  &installw;
  &runtime;
  &user-manag;
  &manage-ag;
  &client-auth;
  &charset;
  &maintenance;
  &backup;
  &monitoring;
  &diskusage;
  &wal;
  &regress;

 </part>

 <part id="client-interfaces">
  <title>Client Interfaces</title>

  <partintro>
   <para>
    This part describes the client programming interfaces distributed
    with <productname>PostgreSQL</>.  Each of these chapters can be
    read independently.  Note that there are many other programming
    interfaces for client programs that are distributed separately and
    contain their own documentation.  Readers of this part should be
    familiar with using <acronym>SQL</acronym> commands to manipulate
    and query the database (see <xref linkend="sql">) and of course
    with the programming language that the interface uses.
   </para>
  </partintro>

  &libpq;
  &lobj;
  &ecpg;
181
  &infoschema;
182
  &external-projects;
183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204

 </part>

 <part id="server-programming">
  <title>Server Programming</title>

  <partintro>
   <para>
    This part is about extending the server functionality with
    user-defined functions, data types, triggers, etc.  These are
    advanced topics which should probably be approached only after all
    the other user documentation about <productname>PostgreSQL</> has
    been understood.  This part also describes the server-side
    programming languages available in the
    <productname>PostgreSQL</productname> distribution as well as
    general issues concerning server-side programming languages.  This
    information is only useful to readers that have read at least the
    first few chapters of this part.
   </para>
  </partintro>

  &extend;
205
  &rules;
206 207 208 209 210 211 212 213
  &trigger;

  &xplang;
  &plsql;
  &pltcl;
  &plperl;
  &plpython;

214 215
  &spi;

216
 </part>
217 218

 &reference;
219 220 221 222 223 224 225 226 227 228 229 230 231 232

 <part id="internals">
  <title>Internals</title>

  <partintro>
   <para>
    This part contains assorted information that can be of use to
    <productname>PostgreSQL</> developers.
   </para>
  </partintro>

  &arch-dev;
  &catalogs;
  &protocol;
233 234 235
  &sources;
  &nls;
  &plhandler;
236
  &geqo;
237
  &indexcost;
238
  &gist;
239
  &filelayout;
240
  &page;
241
  &bki;
242 243 244 245 246 247

 </part>

 <part id="appendixes">
  <title>Appendixes</title>

248
  &errcodes;
249 250 251 252 253 254 255 256 257 258 259 260 261
  &datetime;
  &keywords;
  &features;
  &release;
  &cvs;
  &docguide;

 </part>

 &biblio;
 &bookindex;

</book>