blob: 14fb80aa2eadadf9fe9a0b7db7db32e7697466db (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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
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
|
<!--
$Header: /cvsroot/pgsql/doc/src/sgml/Attic/user.sgml,v 1.35 2002/11/15 03:11:17 momjian Exp $
-->
<book id="user">
<!-- Title information -->
<title>PostgreSQL &version; User's Guide</title>
<bookinfo>
<corpauthor>The PostgreSQL Global Development Group</corpauthor>
&legal;
</bookinfo>
<preface id="user-preface">
<title>Preface</title>
&intro;
&history;
<sect1 id="user-preface-thisbook">
<title>What's In This Book</title>
<para>
This book 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
<acronym>SQL</acronym> data commands. The rest of the book treats
several aspects that are important for tuning a database for
optimal performance.
</para>
<para>
The information in this book 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
book is presented in a narrative fashion in topical units.
Readers looking for a complete description of a particular command
should look into the &cite-reference;.
</para>
<para>
Readers of this book should know how to connect to a <productname>PostgreSQL</>
database and issue <acronym>SQL</acronym> commands. Readers that are unfamiliar with
these issues are encouraged to read the &cite-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>
<para>
This book covers <productname>PostgreSQL &version;</productname>
only. For information on other versions, please read the
documentation that accompanies that release.
</para>
</sect1>
&info;
¬ation;
&problems;
</preface>
&syntax;
&ddl;
&dml;
&queries;
&datatype;
&func;
&typeconv;
&indices;
&mvcc;
&perform;
<!-- appendices -->
&datetime;
&keywords;
&features;
&biblio;
<![%single-book;[
&bookindex;
]]>
</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:
-->
|
