PostgreSQL Developer's Handbook

Front Cover
Sams Publishing, 2002 - Computers - 753 pages

PostgreSQL is an object-relational database server that is widely considered to be the world s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP.

PostgreSQL Developer s Handbook provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/pgSQL, and the most important programming interfaces. The book introduces the reader to the language and syntax of PostgreSQL and then moves quickly into advanced programming topics.

 

What people are saying - Write a review

User ratings

5 stars
4
4 stars
1
3 stars
0
2 stars
0
1 star
1

Don't get digital copy! It's not a normal PDF!

User Review  - Douglas M - Borders

DO NOT GET THE DIGITAL DOWNLOAD OF THIS BOOK!!!! IT IS NOT A PDF FILE! At least not a pdf file in the traditional sense. You don't get a link to download a pdf, instead you get a link to download a ... Read full review

User Review - Flag as inappropriate

Storing Backup

Contents

Introduction
1
PostgreSQL
7
Preparing
15
Starting the Server and Creating Databases
30
An Introduction to SQL
39
Building a Database
48
Retrieving Data
56
Updating and Deleting Data
82
Embedded SQL C Preprocessor ECPG
296
Perl
314
The DBI Interface and DBD for PostgreSQL
327
DBI Proxies
346
Java 872
372
Python
403
TclTK
420
ODBC
438

Building Complex Data Structures and Modeling Techniques
102
Understanding Transactions
121
PLPGSQL
131
Database Administration
151
Adding Users and Managing User Rights
162
Modifying Databases
172
Security and Access Restrictions
188
Backup and Recovery
193
Backup Strategies and Tools for PostgreSQL
197
Performance Tuning
211
Using EXPLAIN and Understanding the Optimizer
219
Tuning SQL
228
System Performance
236
Programming Interfaces
243
O Open Source Software
441
Part Practical PostgreSQL Solutions
469
Practical PostgreSQL Solutions
471
Generating Multidimensional Results
495
Classification of DataRealWorld Examples
507
Generating Flash with PostgreSQL and PHP
541
PostgreSQL Regression Tests
569
Extending PostgreSQLs Core Features
579
Date Calculations
607
Using PostgreSQL with Microsoft Office
677
Index
713
P89FOUP
722
Copyright

Other editions - View all

Common terms and phrases

About the author (2002)

Ewald Geschwinde and Hans-J rgen Sch nig are partners in Cybertec Geschwinde & Sch nig OEG (www.cybertec.at), a company based in Vienna, Austria that provides commercial PostgreSQL support, training, tuning, and remote administration to international clients. They also offer training through the first PostgreSQL Academy. Their accomplishments include the creation of a popular Webshop using PostgreSQL and the implementation of a massive scientific database containing data on millions of Austrian social insurance recipients.

Before founding Cybertec, both Geschwinde and Sch nig worked at Synthesis, an Austrian research company focusing on forecasting the Austrian labor market. While there, the worked with Unix systems and automated text production using EFEU, LaTex, and Perl.

Bibliographic information