PostgreSQL is a free, open-source relational database management system, known as the most successful database in the world. It has a long history dating back to 1985, started as a research project at the University of California, Berkeley. It not only supports many advanced features, but its performance can even exceed that of most databases in many application scenarios, including commercial databases. In fact, PostgreSQL has been considered one of the most popular databases in the world, one of the most admired databases by developers, and one of the databases with the strongest user demand.

PostgreSQL: Up and Running will help you understand and use PostgreSQL, an advanced database system. Not only will you learn the enterprise-level features in PostgreSQL, you will also discover that it is not only a database system, but also an excellent application platform. Through a large number of examples, this book shows you how to achieve tasks that are difficult or impossible to accomplish in other databases, fully demonstrating the powerful functions and enterprise-level features of PostgreSQL as a full-stack database.

PostgreSQL: Up and Running mainly introduces the core concepts and features of PostgreSQL 9.x and PostgreSQL 10, but it also covers some advanced features already supported in earlier versions, which are common in newer versions of commercial databases such as Oracle, SQL Server, DB2, but almost non-existent in the open-source database community, as well as PostgreSQL's unique features. For example: ANSI-SQL syntax, external data wrapper enhancements, full-text search functions and operators, XML syntax, logical replication, LATERAL queries, enhanced JSON support, materialized views, window functions, ordinary CTE expressions, recursive CTE expressions, streaming replication, etc.

PostgreSQL: Up and Running is suitable for readers who have some experience in using relational databases, but it is not required to have used PostgreSQL. The book will compare the mechanisms used by PostgreSQL and other databases to handle the same task. If you have never used a database before, you can learn the functions and usage of PostgreSQL through this book. However, the book will not introduce too much basic knowledge about SQL or relational database theory. We recommend that you read other related books to understand these contents. In short, PostgreSQL: Up and Running is a practical PostgreSQL quick start guide that can help readers quickly learn, understand and use this great database.

What You Will Learn

  • Learn basic administration tasks such as role management, database creation, backup, and restore
  • Apply the psql command-line utility and the pgAdmin graphical administration tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn powerful SQL constructs not generally found in other databases
  • Use several different languages to write database functions
  • Tune your queries to run as fast as your hardware will allow
  • Query external and variegated data sources with foreign data wrappers
  • Learn how to use built-in replication to replicate data

Table Of Contents

  • 1. The Basics
  • 2. Database Administration
  • 3. psql
  • 4. Using pgAdmin
  • 5. Data Types
  • 6. Tables, Constraints, and Indexes
  • 7. SQL: The PostgreSQL Way
  • 8. Writing Functions
  • 9. Query Performance Tuning
  • 10. Replication and External Data
  • A. Installing PostgreSQL
  • B. PostgreSQL Packaged Command-Line Tools

Book Example Codes

Download URLs

Format Download Size
PostgreSQL: Up and Running, 3rd Edition
PDF 6.49 MB
PostgreSQL: Up and Running, 2nd Edition
PDF 4.10 MB
(Homepage)