Beginning Databases with PostgreSQL

Beginning Databases with PostgreSQL

by STONES, Neil Matthew

Paperback(2001)

$35.99 $39.99 Save 10% Current price is $35.99, Original price is $39.99. You Save 10%.

Product Details

ISBN-13: 9781861005151
Publisher: Apress
Publication date: 10/10/2001
Series: Beginning Ser.
Edition description: 2001
Pages: 650
Product dimensions: (w) x (h) x 0.05(d)

Table of Contents

Introduction1
Chapter 1Introduction to PostgreSQL7
Programming with Data7
Flat File Databases8
What is a Database?10
Database Types10
Query Languages13
Database Management Systems15
What is PostgreSQL?16
Chapter 2Relational Database Principles23
Spreadsheets23
Putting Data Into a Database28
Adding Additional Information32
Designing Tables36
Basic Data Types42
The Sample Database45
Summary45
Chapter 3Getting Started with PostgreSQL47
Install or Upgrade?48
Installing PostgreSQL from the Linux Binaries48
Installing PostgreSQL From the Source Code52
Installing PostgreSQL on Windows65
Summary77
Chapter 4Accessing Your Data79
Using psql80
Simple SELECT Statements82
Performing Calculations89
Choosing the Rows90
Comparisons Using Other Types96
Multiple Tables103
Relating Three Tables109
Summary114
Chapter 5PostgreSQL Graphical Tools117
psql117
ODBC124
pgAdmin128
Kpsql132
PgAccess132
Microsoft Access135
Microsoft Excel140
Resources144
Summary144
Chapter 6Data Interfacing147
Adding Data to the Database147
Updating Data in the Database163
Deleting Data from the Database166
Summary168
Chapter 7Advanced Data Selection171
Aggregate Functions171
The UNION Join181
Subqueries183
Self Joins190
Outer Joins191
Summary195
Chapter 8Data Definition and Manipulation197
Data Types197
PostgreSQL Special Types204
Manipulating Tables210
Views218
Foreign Key Constraints222
Summary229
Chapter 9Transactions and Locking231
What are Transactions?232
Transaction with Single Users235
Transactions with Multiple Users238
Locking245
Summary249
Chapter 10Stored Procedures and Triggers253
Operators254
Functions259
Procedural Languages261
Getting Started with PL/pgSQL262
Anatomy of a Stored Procedure266
SQL Functions281
Triggers282
Why Stored Procedures and Triggers?288
Summary289
Chapter 11PostgreSQL Administration291
Default Installation292
Server Control295
Users298
Data Maintenance304
Database Security311
Configuration Options313
Performance316
Summary321
Chapter 12Database Design323
Understanding the Problem323
What is a Good Database Design?324
Stages in Database Design326
Convert to a Physical Model336
Normal Forms343
Common Patterns345
Resources348
Summary348
Chapter 13Accessing PostgreSQL From C Using libpq351
Using the libpq Library352
Database Connections353
Executing SQL with libpq357
Transactions361
Printing Query Results365
Cursors368
Binary Values374
Asynchronous Functionality374
Summary379
Chapter 14Accessing PostgreSQL From C Using Embedded SQL381
A First Embedded SQL Program382
Summary405
Chapter 15Accessing PostgreSQL from PHP407
Adding PostgreSQL Support to PHP408
Using the PHP API for PostgreSQL409
Summary427
Chapter 16Accessing PostgreSQL From Perl429
The pgsql_perl5 or Pg Module430
Using pgsql_perl5431
The Perl DBI437
Summary450
Chapter 17Accessing PostgreSQL from Java453
JDBC Overview453
JDBC Drivers454
Building the PostgreSQL JDBC Driver455
DriverManager and Driver456
Connections460
JDBC Resultsets465
JDBC Statements472
SQL Exceptions and Warnings479
A JDBC GUI Application480
Summary497
Chapter 18Further Information and Resources499
Non-Relational Storage499
OLTP, OLAP, and Other Database Terminology500
Resources502
Summary504
Appendix APostgreSQL Database Limits507
Appendix BPostgreSQL data types511
Logical Types511
Exact Number Types512
Approximate Number Types512
Temporal Types513
Character Types513
Geometric Types514
Miscellaneous Types514
Appendix CPostgreSQL SQL Syntax517
PostgreSQL SQL Commands517
PostgreSQL SQL Syntax518
Appendix DPsql Reference531
Appendix EDatabase Schema and Tables535
Appendix FLarge Objects Support in PostgreSQL539
Adding Images to the Database539
Index547

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Beginning Databases with PostgreSQL 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
This is the best book that I found so far on learning the PostgreSQL database. It teaches everyting you'll need to write applications using Posgres and does it in a very clear and concise manner. It also covers many languages which can be used with Postgres to create very powerful applications. One thing that I would recommend is adding Python to that list.