aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/postgres.sgml
blob: 22a74d95f61ddc797308a1b8fbb43e1f00fad29b (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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
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
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
<!-- postgres.sgml
-
- Postgres integrated documentation.
- Other subset docs should be copied and shrunk from here.
- thomas 1998-02-23
-
- -->
<!doctype book PUBLIC "-//Davenport//DTD DocBook V3.0//EN" [
<!entity intro    SYSTEM "intro.sgml">
<!entity arch     SYSTEM "arch.sgml">
<!entity start    SYSTEM "start.sgml">
<!entity query    SYSTEM "query.sgml">

<!entity advanced SYSTEM "advanced.sgml">
<!entity environ  SYSTEM "environ.sgml">
<!entity manage   SYSTEM "manage.sgml">
<!entity datatype SYSTEM "datatype.sgml">
<!entity array    SYSTEM "array.sgml">
<!entity inherit  SYSTEM "inherit.sgml">
<!entity query-ug SYSTEM "query-ug.sgml">
<!entity storage  SYSTEM "storage.sgml">
<!entity psql     SYSTEM "psql.sgml">
<!entity pgaccess SYSTEM "pgaccess.sgml">

<!entity start-ag SYSTEM "start-ag.sgml">
<!entity install  SYSTEM "install.sgml">
<!entity recovery SYSTEM "recovery.sgml">
<!entity regress  SYSTEM "regress.sgml">
<!entity ports    SYSTEM "ports.sgml">
<!entity release  SYSTEM "release.sgml">

<!entity intro-pg SYSTEM "intro-pg.sgml">
<!entity arch-pg  SYSTEM "arch-pg.sgml">
<!entity extend   SYSTEM "extend.sgml">
<!entity rules    SYSTEM "rules.sgml">
<!entity xfunc    SYSTEM "xfunc.sgml">
<!entity xtypes   SYSTEM "xtypes.sgml">
<!entity xoper    SYSTEM "xoper.sgml">
<!entity xaggr    SYSTEM "xaggr.sgml">
<!entity xindex   SYSTEM "xindex.sgml">
<!entity gist     SYSTEM "gist.sgml">
<!entity dfunc    SYSTEM "dfunc.sgml">
<!entity lobj     SYSTEM "lobj.sgml">
<!entity trigger  SYSTEM "trigger.sgml">
<!entity spi      SYSTEM "spi.sgml">
<!entity func-ref SYSTEM "func-ref.sgml">
<!entity libpq    SYSTEM "libpq.sgml">
<!entity libpgtcl SYSTEM "libpgtcl.sgml">
<!entity ecpg     SYSTEM "ecpg.sgml">
<!entity odbc     SYSTEM "odbc.sgml">
<!entity jdbc     SYSTEM "jdbc.sgml">

<!entity arch-dev SYSTEM "arch-dev.sgml">
<!entity geqo     SYSTEM "geqo.sgml">
<!entity protocol SYSTEM "protocol.sgml">
<!entity compiler SYSTEM "compiler.sgml">
<!entity docguide SYSTEM "docguide.sgml">
<!entity biblio   SYSTEM "biblio.sgml">
<!entity contacts SYSTEM "contacts.sgml">
]>
<!-- entity manpages SYSTEM "man/manpages.sgml" subdoc -->
<Book>

<!-- Title information -->

<Title>PostgreSQL</Title>
<BookInfo>
    <ReleaseInfo>Covering v6.3 for general release</ReleaseInfo>
    <BookBiblio>
    <AuthorGroup>
      <CorpAuthor>The PostgreSQL Development Team</CorpAuthor>
    </AuthorGroup>
<!-- editor in authorgroup is not supported
    <AuthorGroup>
-->
      <Editor>
        <FirstName>Thomas</FirstName>
        <SurName>Lockhart</SurName>
        <Affiliation>
          <OrgName>Caltech/JPL</OrgName>
        </Affiliation>
      </Editor>
<!--
    </AuthorGroup>
-->
 
<!--
    <AuthorInitials>TGL</AuthorInitials>
-->

    <Date>(last updated 1998-02-23)</Date>
    </BookBiblio>

<LegalNotice>
<Para>
<ProductName>PostgreSQL</ProductName> is copyright (C) 1998 by the Postgres Global Development Group.
</Para>
</LegalNotice>

</BookInfo>

<!--
<TOC> </TOC>
<LOT> </LOT>
-->

<!--
<Dedication>
<Para>
Your name here...
</Para>
</Dedication>
-->

<Preface>
<Title>Summary</Title>

<Para>
<ProductName>Postgres</ProductName>, 
 developed originally in the UC Berkeley Computer Science Department,
 pioneered many of the object-relational concepts
 now becoming available in some commercial databases.
It provides SQL92/SQL3 language support,
 transaction integrity, and type extensibility.
 <ProductName>PostgreSQL</ProductName> is a public-domain, open source descendant
 of this original Berkeley code.
</Para>
</Preface>

<Part>
<Title>Tutorial</Title>
<PartIntro>
<Para>
Introduction for new users.
</Para>
</PartIntro>
&intro;
&arch;
&start;
&query;
&advanced;
</Part>

<Part>
<Title>User's Guide</Title>
<PartIntro>
<Para>
Information for users.
</Para>
</PartIntro>
&environ;
&manage;
&datatype;
&array;
&inherit;
&query-ug;
&storage;
&psql;
&pgaccess;
</Part>

<Part>
<Title>Administrator's Guide</Title>
<PartIntro>
<Para>
Installation and maintenance information.
</Para>
</PartIntro>
&ports;
&install;
&start-ag;
&recovery;
&regress;
&release;
</Part>

<Part>
<Title>Programmer's Guide</Title>
<PartIntro>
<Para>
Information for extending <ProductName>Postgres</ProductName>.
</Para>
</PartIntro>
&intro-pg;
&arch-pg;
&extend;
&xfunc;
&xtypes;
&xoper;
&xaggr;
&rules;
&xindex;
&gist;
&dfunc;
&trigger;
&spi;
&libpq;
</Part>

<Part>
<Title>Reference</Title>
<PartIntro>
<Para>
User and programmer interfaces.
</Para>
</PartIntro>
&func-ref;
&lobj;
&ecpg;
&libpq;
&libpgtcl;
&odbc;
&jdbc;
</Part>

<Part>
<Title>Developer's Guide</Title>
<PartIntro>
<Para>
The Developer's Guide includes discussion of design decisions and suggestions for
future development.
</Para>
</PartIntro>
&arch-dev;
&geqo;
&protocol;
&compiler;
</Part>

<Part>
<Title>Appendices</Title>
<PartIntro>
<Para>
Additional related information.
</Para>
</PartIntro>
&docguide;
&contacts;
&biblio;
</Part>

<INDEX> </INDEX>

</Book>