Contents

• Dedication
• Contents
• List of Figures
• List of Tables
• Foreword
• Preface
• Acknowledgments
• History of POSTGRESQL
  • Introduction
  • University of California at Berkeley
  • Development Leaves Berkeley
  • POSTGRESQL Global Development Team
  • Open Source Software
  • Summary
• Issuing Database Commands
  • Starting a Database Session
  • Controlling a Session
  • Getting Help
  • Exiting a Session
  • Summary
• Basic SQL Commands
  • Relational Databases
  • Creating Tables
  • Adding Data with INSERT
  • Viewing Data with SELECT
  • Selecting Specific Rows with WHERE
  • Removing Data with DELETE
  • Modifying Data with UPDATE
  • Sorting Data with ORDER BY
  • Destroying Tables
  • Summary
• Customizing Queries
  • Data Types
  • Quotes Inside Text
  • Using NULL Values
  • Controlling DEFAULT Values
  • Column Labels
  • Comments
  • AND/OR Usage
  • Range of Values
  • LIKE Comparison
  • Regular Expressions
  • CASE Clause
  • Distinct Rows
  • Functions and Operators
  • SET, SHOW, and RESET
  • Summary
• SQL Aggregates
  • Aggregates
  • Using GROUP BY
  • Using HAVING
  • Query Tips
  • Summary
• Joining Tables
  • Table and Column References
  • Joined Tables
  • Creating Joined Tables
  • Performing Joins
  • Three- and Four-Table Joins
  • Additional Join Possibilities
  • Choosing a Join Key
  • One-to-Many Joins
  • Unjoined Tables
  • Table Aliases and Self-joins
  • Non-equijoins
  • Ordering Multiple Parts
  • Primary and Foreign Keys
  • Summary
• Numbering Rows
  • Object Identification Numbers (OIDs)
  • Object Identification Number Limitations
  • Sequences
  • Creating Sequences
  • Using Sequences to Number Rows
  • Serial Column Type
  • Manually Numbering Rows
  • Summary
• Combining SELECTs
  • UNION, EXCEPT, and INTERSECT Clauses
  • Subqueries
  • Outer Joins
  • Subqueries in Non-SELECT Queries
  • UPDATE with FROM
  • Inserting Data Using SELECT
  • Creating Tables Using SELECT
  • Summary
• Data Types
  • Purpose of Data Types
  • Installed Types
  • Type Conversion Using CAST
  • Support Functions
  • Support Operators
  • Support Variables
  • Arrays
  • Large Objects (BLOBs)
  • Summary
• Transactions and Locks
  • Transactions
  • Multistatement Transactions
  • Visibility of Committed Transactions
  • Read Committed and Serializable Isolation Levels
  • Locking
  • Deadlocks
  • Summary
• Performance
  • Indexes
  • Unique Indexes
  • CLUSTER
  • VACUUM
  • VACUUM ANALYZE
  • EXPLAIN
  • Summary
• Controlling Results
  • LIMIT
  • Cursors
  • Summary
• Table Management
  • Temporary Tables
  • ALTER TABLE
  • GRANT and REVOKE
  • Inheritance
  • Views
  • Rules
  • LISTEN and NOTIFY
  • Summary
• Constraints
  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • Foreign Key/REFERENCES
  • CHECK
  • Summary
• Importing and Exporting Data
  • Using COPY
  • COPY File Format
  • DELIMITERS
  • COPY Without Files
  • Backslashes and NULL Values
  • COPY Tips
  • Summary
• Database Query Tools
  • Psql
  • Pgaccess
  • Summary
• Programming Interfaces
  • C Language Interface (LIBPQ)
  • Pgeasy (LIBPGEASY)
  • Embedded C (ECPG)
  • C++ (LIBPQ++)
  • Compiling Programs
  • Assignment to Program Variables
  • ODBC
  • Java (JDBC)
  • Scripting Languages
  • Perl
  • TCL/TK (PGTCLSH/PGTKSH)
  • Python
  • PHP
  • Installing Scripting Languages
  • Summary
• Functions and Triggers
  • Functions
  • SQL Functions
  • PL/PGSQL Functions
  • Triggers
  • Summary
• Extending POSTGRESQL Using C
  • Write the C Code
  • Compile the C Code
  • Register the New Functions
  • Create Operators, Types, and Aggregates
  • Summary
• Administration
  • Files
  • Creating Users
  • Creating Databases
  • Access Configuration
  • Backup and Restore
  • Server Start-up and Shutdown
  • Monitoring
  • Performance
  • System Tables
  • Internationalization
  • Upgrading
  • Summary
• Additional Resources
  • Mailing List Support
  • Supplied Documentation
  • Commercial Support
  • Modifying the Source Code
  • Frequently Asked Questions (FAQs)
• Installation
• PostgreSQL Nonstandard Features by Chapter
• Reference Manual
  • ABORT
  • ALTER GROUP
  • ALTER TABLE
  • ALTER USER
  • BEGIN
  • CLOSE
  • CLUSTER
  • COMMENT
  • COMMIT
  • COPY
  • CREATE AGGREGATE
  • CREATE CONSTRAINT TRIGGER
  • CREATE DATABASE
  • CREATE FUNCTION
  • CREATE GROUP
  • CREATE INDEX
  • CREATE LANGUAGE
  • CREATE OPERATOR
  • CREATE RULE
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE USER
  • CREATE VIEW
  • createdb
  • createlang
  • createuser
  • DECLARE
  • DELETE
  • DROP AGGREGATE
  • DROP DATABASE
  • DROP FUNCTION
  • DROP GROUP
  • DROP INDEX
  • DROP LANGUAGE
  • DROP OPERATOR
  • DROP RULE
  • DROP SEQUENCE
  • DROP TABLE
  • DROP TRIGGER
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • dropdb
  • droplang
  • dropuser
  • ecpg
  • END
  • EXPLAIN
  • FETCH
  • GRANT
  • initdb
  • initlocation
  • INSERT
  • ipcclean
  • LISTEN
  • LOAD
  • LOCK
  • MOVE
  • NOTIFY
  • pg_ctl
  • pg_dump
  • pg_dumpall
  • pg_passwd
  • pg_upgrade
  • pgaccess
  • pgtclsh
  • pgtksh
  • postgres
  • postmaster
  • psql
  • REINDEX
  • RESET
  • REVOKE
  • ROLLBACK
  • SELECT
  • SELECT INTO
  • SET
  • SHOW
  • TRUNCATE
  • UNLISTEN
  • UPDATE
  • VACUUM
  • vacuumdb
• Bibliography
• Index