PostgreSQL: A Comprehensive Guide to Building, Programming, and Administering PostgresSQL Databases

Лицевая обложка
Sams Publishing, 2003 - Всего страниц: 790

PostgreSQL

is the world¿s most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read guide to this award-winning database. This book starts with a thorough overview of SQL, a description of all PostgreSQL data types, and a complete explanation of PostgreSQL commands.

If you are a developer or an administrator, you¿ll love the chapter that explores PostgreSQL performance. The authors explain how PostgreSQL stores data on disk (and in memory) and how to measure and influence the effectiveness of PostgreSQL¿s caching mechanisms. You¿ll also learn how PostgreSQL generates and evaluates execution plans. The authors explain all of the query operators that can appear in the results of an EXPLAIN command, describing the performance implications of each operator as well as the conditions which will cause PostgreSQL to use that operator.

PostgreSQL is also a complete guide for the developer. Whether you¿re developing with C, C++, ODBC, Embedded SQL, Java, Tcl/Tk, Perl, Python or PHP, you¿ll find a comprehensive description of the PostgreSQL API for your language of choice. Easy to follow exercises will walk you through the development of working applications that fully demonstrate the features offered by each API. You will also find a chapter that describes the PL/pgSQL server-side procedural language, learning how to build triggers, functions, and stored-procedures. The authors have even included a chapter that walks you through the process of extending the PostgreSQL server with custom-written C functions and new data types. The accompanying web site, www.conjectrix.com, contains downloadable versions of all of the sample code and a wealth of PostgreSQL-related resources.

The last section of PostgreSQL was written for the PostgreSQL administrator. You will learn how to install PostgreSQL on Windows, Linux, and Unix systems, from source code or from pre-compiled installers. The authors have described all of the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all of the authentication protocols that you can choose from and describes how to secure your database, both internally and externally. If you have to support a multi-national environment, you will find the chapter on internationalization and localization to be invaluable.

You won¿t find a more complete guide to PostgreSQL anywhere. The authors have made PostgreSQL approachable by leading the reader from basic concepts to advanced features. Whether you¿re a database beginner or an advanced user, you will find this book a valuable addition to your library.

 

Отзывы - Написать отзыв

Пользовательский отзыв - Нарушение правил

It is very interesting book about programming database object for Postgresql database. The book will be useful speciality for beginners.

Избранные страницы

Содержание

I
1
III
2
V
3
VI
5
VII
7
VIII
8
X
11
XI
12
CLXXIX
317
CLXXX
319
CLXXXI
321
CLXXXII
330
CLXXXIII
333
CLXXXIV
339
CLXXXV
341
CLXXXVI
346

XII
17
XIII
19
XIV
22
XV
24
XVI
26
XVIII
29
XIX
30
XX
31
XXII
32
XXIII
33
XXVI
34
XXVII
44
XXVIII
49
XXIX
52
XXXI
54
XXXIII
55
XXXV
56
XXXVI
58
XXXVII
61
XXXVIII
63
XXXIX
65
XL
66
XLII
69
XLIII
71
XLIV
73
XLV
74
XLVI
75
XLVIII
76
XLIX
78
L
79
LI
80
LII
81
LIII
83
LIV
84
LV
88
LVI
90
LIX
91
LXI
92
LXII
93
LXIV
100
LXV
103
LXIX
104
LXXI
105
LXXII
106
LXXV
107
LXXVIII
108
LXXIX
113
LXXX
119
LXXXI
120
LXXXII
121
LXXXIII
122
LXXXIV
123
LXXXV
124
LXXXVI
125
LXXXVII
128
LXXXIX
129
XC
131
XCI
134
XCII
136
XCIII
137
XCIV
138
XCVI
140
XCVII
143
XCVIII
145
XCIX
149
C
150
CI
156
CIII
158
CIV
160
CV
162
CVI
163
CVII
164
CVIII
167
CIX
168
CX
169
CXI
174
CXIII
175
CXIV
181
CXV
182
CXVI
186
CXVII
187
CXVIII
190
CXIX
191
CXXI
192
CXXIII
193
CXXIV
194
CXXV
195
CXXVI
196
CXXVIII
199
CXXX
200
CXXXI
201
CXXXIII
202
CXXXIV
204
CXXXV
207
CXXXVI
209
CXXXVII
211
CXXXVIII
212
CXL
213
CXLII
214
CXLIII
217
CXLIV
218
CXLVII
219
CXLVIII
221
CXLIX
227
CL
236
CLII
237
CLIII
239
CLIV
240
CLV
244
CLVI
245
CLVII
257
CLVIII
259
CLIX
260
CLX
262
CLXII
265
CLXIII
266
CLXV
267
CLXVI
274
CLXVII
291
CLXIX
295
CLXX
297
CLXXI
302
CLXXII
305
CLXXIII
307
CLXXIV
308
CLXXVI
309
CLXXVII
311
CLXXVIII
315
CLXXXVII
347
CLXXXVIII
349
CLXXXIX
350
CXC
353
CXCI
355
CXCII
357
CXCIII
361
CXCIV
363
CXCV
364
CXCVII
365
CXCVIII
366
CXCIX
373
CC
376
CCI
384
CCII
387
CCIII
395
CCIV
397
CCV
398
CCVI
400
CCVII
402
CCVIII
403
CCX
410
CCXI
415
CCXII
420
CCXIII
430
CCXIV
431
CCXV
432
CCXIX
433
CCXXII
438
CCXXV
442
CCXXVI
450
CCXXVII
458
CCXXVIII
468
CCXXX
469
CCXXXI
470
CCXXXIII
471
CCXXXVI
472
CCXXXVIII
476
CCXXXIX
480
CCXL
485
CCXLI
487
CCXLII
488
CCXLIII
496
CCXLIV
499
CCXLV
500
CCXLVIII
501
CCLI
503
CCLII
505
CCLIII
507
CCLIV
511
CCLV
514
CCLVI
524
CCLVII
526
CCLVIII
537
CCLIX
539
CCLX
542
CCLXII
547
CCLXIII
550
CCLXIV
554
CCLXV
556
CCLXVI
560
CCLXVII
569
CCLXVIII
570
CCLXIX
571
CCLXX
572
CCLXXI
573
CCLXXIII
583
CCLXXIV
585
CCLXXV
586
CCLXXVI
600
CCLXXVII
605
CCLXXVIII
609
CCLXXIX
611
CCLXXX
612
CCLXXXII
615
CCLXXXIII
618
CCLXXXIV
624
CCLXXXV
635
CCLXXXVI
637
CCLXXXVII
639
CCLXXXVIII
640
CCXC
641
CCXCIII
642
CCXCVI
643
CCXCVII
645
CCXCVIII
646
CCXCIX
653
CCC
660
CCCII
663
CCCIII
664
CCCIV
666
CCCVI
671
CCCVII
672
CCCVIII
673
CCCIX
676
CCCX
680
CCCXI
684
CCCXII
689
CCCXIII
691
CCCXIV
694
CCCXVI
696
CCCXVIII
699
CCCXIX
701
CCCXXI
705
CCCXXII
706
CCCXXIV
707
CCCXXV
709
CCCXXVI
710
CCCXXVII
713
CCCXXVIII
716
CCCXXIX
719
CCCXXXI
720
CCCXXXII
722
CCCXXXIII
723
CCCXXXIV
724
CCCXXXV
728
CCCXXXVI
729
CCCXXXVIII
730
CCCXL
733
CCCXLI
735
CCCXLII
736
CCCXLIII
737
CCCXLV
740
CCCXLVI
741
CCCXLVII
745
CCCXLVIII
747
Авторские права

Другие издания - Просмотреть все

Часто встречающиеся слова и выражения

Об авторе (2003)

Korry Douglas is the Director of Research and Development for Appx Software. Over the last two decades, he has worked on the design and implementation of a number of high-level, high-productivity languages and development environments. His products interface with many relational (and non-relational) databases. Working with so many different database products (Oracle, Sybase, SQL Server, DB2, PostgreSQL, MySQL, MSQL) has given him a broad understanding of the commonalities of, and differences between, databases.

Susan Douglas is the President and CEO of Conjectrix, Inc., a software company specializing in database technologies and security tools. Consulting to the end-user community has given her widespread database experience and a real appreciation for high-quality programs and flexible tools powerful enough to handle data well and intuitive enough to actually use.

Korry and his wife (and best friend) Susan raise horses in rural Virginia. Both are natives of the Pacific Northwest, but prefer the sunshine and open spaces offered by Virginia. They both telecommute, preferring to spend as much time as possible with their 200 or so animal friends (who never complain about buggy code, inelegant design, or poor performance). Susan is an avid equestrienne; Korry gets to clean the barn.

Библиографические данные