更新时间：2021-04-02 20:32:33
coverpage
Learning PostgreSQL
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Relational Databases
Database management systems
Relational algebra
Data modeling
Summary
Chapter 2. PostgreSQL in Action
An overview of PostgreSQL
PostgreSQL capabilities
Installing PostgreSQL
Chapter 3. PostgreSQL Basic Building Blocks
Database coding
PostgreSQL objects hierarchy
PostgreSQL high-level object interaction
PostgreSQL database components
Chapter 4. PostgreSQL Advanced Building Blocks
Views
Indexes
Functions
PostgreSQL user-defined data types
Triggers and rule systems
Chapter 5. SQL Language
SQL fundamentals
Querying the data with the SELECT statement
Changing the data in the database
Chapter 6. Advanced Query Writing
Common table expressions
Window functions
Advanced SQL
Transaction isolation and multiversion concurrency control
Chapter 7. Server-Side Programming with PL/pgSQL
Introduction
PostgreSQL function parameters
The PostgreSQL PL/pgSQL control statements
Exception handling
Dynamic SQL
Chapter 8. PostgreSQL Security
Authentication in PostgreSQL
PostgreSQL default access privileges
PostgreSQL security levels
Encrypting data
Chapter 9. The PostgreSQL System Catalog and System Administration Functions
The system catalog
Getting the database cluster and client tools version
Terminating and canceling user sessions
Setting and getting database cluster settings
Getting the database and database object size
Cleaning up the database
Cleaning up data in the database
Managing database locks
Adding missing indexes on foreign keys and altering the default statistic
Getting the views dependency tree
Chapter 10. Optimizing Database Performance
PostgreSQL configuration tuning
Tuning PostgreSQL queries
Cross column correlation
Table partitioning
Chapter 11. Beyond Conventional Data types
PostgreSQL arrays
Hash store
The PostgreSQL JSON data type
A PostgreSQL full text search
Chapter 12. Testing
Unit testing
Schema difference
The interfaces test
PostgreSQL benchmarks
Chapter 13. PostgreSQL JDBC
Introduction to JDBC
Connecting to a PostgreSQL database
Issuing a query and processing the results
Function handling
Design considerations
Chapter 14. PostgreSQL and Hibernate
Introduction to ORM and Hibernate
