Books & Videos

Table of Contents

  1. Chapter 1 The Basics

    1. Where to Get PostgreSQL

    2. Administration Tools

    3. PostgreSQL Database Objects

    4. What’s New in Latest Versions of PostgreSQL?

    5. Database Drivers

    6. Where to Get Help

    7. Notable PostgreSQL Forks

  2. Chapter 2 Database Administration

    1. Configuration Files

    2. Managing Connections

    3. Roles

    4. Database Creation

    5. Privileges

    6. Extensions

    7. Backup and Restore

    8. Managing Disk Storage with Tablespaces

    9. Verboten Practices

  3. Chapter 3 psql

    1. Environment Variables

    2. Interactive versus Noninteractive psql

    3. psql Customizations

    4. psql Gems

    5. Importing and Exporting Data

    6. Basic Reporting

  4. Chapter 4 Using pgAdmin

    1. Getting Started

    2. pgAdmin Features

    3. pgScript

    4. Graphical Explain

    5. Job Scheduling with pgAgent

  5. Chapter 5 Data Types

    1. Numerics

    2. Characters and Strings

    3. Temporals

    4. Arrays

    5. Range Types

    6. JSON

    7. XML

    8. Custom and Composite Data Types

  6. Chapter 6 Tables, Constraints, and Indexes

    1. Tables

    2. Constraints

    3. Indexes

  7. Chapter 7 SQL: The PostgreSQL Way

    1. Views

    2. Handy Constructions

    3. FILTER Clause for Aggregates

    4. Window Functions

    5. Common Table Expressions

    6. Lateral Joins

  8. Chapter 8 Writing Functions

    1. Anatomy of PostgreSQL Functions

    2. Writing Functions with SQL

    3. Writing PL/pgSQL Functions

    4. Writing PL/Python Functions

    5. Writing PL/V8, PL/CoffeeScript, and PL/LiveScript Functions

  9. Chapter 9 Query Performance Tuning

    1. EXPLAIN

    2. Gathering Statistics on Statements

    3. Guiding the Query Planner

    4. Caching

    5. Writing Better Queries

  10. Chapter 10 Replication and External Data

    1. Replication Overview

    2. Setting Up Replication

    3. Foreign Data Wrappers

  11. Appendix Installing PostgreSQL

    1. Windows, Desktop Linux

    2. CentOS, Fedora, Red Hat, Scientific Linux

    3. Debian, Ubuntu

    4. FreeBSD

    5. Mac OS X

  12. Appendix PostgreSQL Packaged Command-Line Tools

    1. Database Backup Using pg_dump

    2. Server Backup: pg_dumpall

    3. Database Restore: pg_restore

    4. psql Interactive Commands

    5. psql Noninteractive Commands