- Learning PostgreSQL
- Table of Contents
- Learning PostgreSQL
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Relational Databases
- 2. PostgreSQL in Action
- 3. PostgreSQL Basic Building Blocks
- 4. PostgreSQL Advanced Building Blocks
- 5. SQL Language
- SQL fundamentals
- Querying the data with the SELECT statement
- Changing the data in the database
- Summary
- 6. Advanced Query Writing
- 7. Server-Side Programming with PL/pgSQL
- 8. PostgreSQL Security
- 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
- Summary
- 10. Optimizing Database Performance
- 11. Beyond Conventional Data types
- 12. Testing
- 13. PostgreSQL JDBC
- 14. PostgreSQL and Hibernate
- Introduction to ORM and Hibernate
- Installation and configuration
- Working with entities
- Summary
- Index
Authors
Salahaldin Juba
Achim Vannahme
Andrey Volkov
Reviewers
Ângelo Marcos Rigo
Dr. Isabel Rosa
Commissioning Editor
Julian Ursell
Acquisition Editor
Tushar Gupta
Greg Wild
Content Development Editor
Parita Khedekar
Technical Editor
Vijin Boricha
Copy Editor
Shruti Iyer
Sonia Mathur
Project Coordinator
Judie Jose
Proofreader
Safis Editing
Indexer
Monica Ajmera Mehta
Graphics
Disha Haria
Production Coordinator
Conidon Miranda
Cover Work
Conidon Miranda
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.