9781565928466

Summary

PostgreSQL is the most robust, object-relational database management system of all the open source database options. It has been open source from the start, and evolves quickly, thanks to the committed, active community of developers behind it. But like many open source applications, it lacks comprehensive, easy-to-use documentation. Practical PostgreSQL fills the information void. Practical PostgreSQL is a fast- paced, business-oriented guide to installing, configuring, and running PostgreSQL. Readers will find all the basics here, such as how to create databases and objects, such as tables, within those databases. Or they can go straight to advanced topics like inheritance, replication, user management, and backup and recovery. The book also introduces the PL/pgSQL procedural language. Finally, a complete PostgreSQL command reference makes "looking it up" easy.

Author Biography

John C. Worsley and Joshua D. Drake are co-owners of Command Prompt, Inc.

Preface	p. ix
Introduction and Installation	p. 1
What Is PostgreSQL?	p. 3
Open Source Free Version	p. 3
PostgreSQL Feature Set	p. 6
Where to Proceed from Here	p. 7
Installing PostgreSQL	p. 9
Preparing for Installation	p. 9
10 Steps to Installing PostgreSQL	p. 13
Using PostgreSQL	p. 31
Understanding SQL	p. 33
Introduction to SQL	p. 33
Introduction to Relational Databases	p. 35
SQL Statements	p. 39
Data Types	p. 59
Tables in PostgreSQL	p. 86
Using SQL with PostgreSQL	p. 91
Introduction to psql	p. 91
Using Tables	p. 95
Adding Data with INSERT and COPY	p. 107
Retrieving Rows with SELECT	p. 112
Modifying Rows with UPDATE	p. 145
Removing Rows with DELETE	p. 148
Using Sub-Queries	p. 150
Using Views	p. 152
Further SQL Application	p. 155
Operators and Functions	p. 157
Operators	p. 157
Functions	p. 175
PostgreSQL Clients	p. 221
The psql Client: Advanced Topics	p. 221
PgAccess: A Graphical Client	p. 238
Advanced Features	p. 247
Indices	p. 247
Advanced Table Techniques	p. 252
Arrays	p. 264
Automating Common Routines	p. 271
Transactions and Cursors	p. 283
Extending PostgreSQL	p. 290
Administrating PostgreSQL	p. 301
Authentication and Encryption	p. 303
Client Authentication	p. 303
Encrypting Sessions	p. 315
Database Management	p. 327
Starting and Stopping PostgreSQL	p. 327
Initializing the Filesystem	p. 336
Creating and Removing a Database	p. 339
Maintaining a Database	p. 347
Backing Up and Restoring Data	p. 353
User and Group Management	p. 369
Managing Users	p. 369
Managing Groups	p. 379
Granting Privileges	p. 383
PostgreSQL Programming	p. 389
PL/pgSQL	p. 391
Adding PL/pgSQL to Your Database	p. 391
Language Structure	p. 394
Using Variables	p. 398
Controlling Program Flow	p. 412
PL/pgSQL and Triggers	p. 428
JDBC	p. 433
Building the PostgreSQL JDBC Driver	p. 434
Using the PostgreSQL Driver	p. 434
Using JDBC	p. 437
Issues Specific to PostgreSQL and JDBC	p. 444
LXP	p. 447
Why Use LXP?	p. 448
Core Features	p. 448
Installing and Configuring LXP	p. 450
Understanding LXP Mark-Up	p. 456
LXP Variables and Objects	p. 459
Using Cookies with LXP	p. 462
Tag Parsing	p. 464
Branching Logic	p. 468
Loop Iteration	p. 473
Content Inclusion	p. 475
Displaying Foreign Tags with [left angle bracket]xtag[right angle bracket]	p. 487
Command Reference	p. 491
PostgreSQL Command Reference	p. 493
Multibyte Encoding Types	p. 599
Backend Options for postgres	p. 601
Binary COPY Format	p. 605
Internal psql Variables	p. 609
Index	p. 613
Table of Contents provided by Syndetics. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

Practical Postgresql

1565928466

Supplemental Materials

Summary

Author Biography

Table of Contents

Supplemental Materials

Rewards Program