Books & Videos

Table of Contents

  1. Chapter 1 The Basics

    1. Where to Get PostgreSQL

    2. Administration Tools

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

    4. Database Drivers

    5. Server and Database Objects

    6. Where to Get Help

  2. Chapter 2 Database Administration

    1. Configuration Files

    2. Setting Up Groups and Login Roles (Users)

    3. Databases and Management

    4. Extensions and Contribs

    5. Backup

    6. Restore

    7. Managing Disk Space with Tablespaces

    8. Verboten

  3. Chapter 3 psql

    1. Interactive psql

    2. Non-Interactive psql

    3. Session Configurations

    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. Numeric Data Types

    2. Arrays

    3. Character Types

    4. Temporal Data Types

    5. XML

    6. Custom and Composite Data Types

  6. Chapter 6 Of Tables, Constraints, and Indexes

    1. Tables

    2. Constraints

    3. Indexes

  7. Chapter 7 SQL: The PostgreSQL Way

    1. SQL Views

    2. Window Functions

    3. Common Table Expressions

    4. Constructions Unique to PostgreSQL

  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. Trigger Functions

    6. Aggregates

  9. Chapter 9 Query Performance Tuning

    1. EXPLAIN and EXPLAIN ANALYZE

    2. Writing Better Queries

    3. Guiding the Query Planner

    4. Caching

  10. Chapter 10 Replication and External Data

    1. Replication Overview

    2. Setting Up Replication

    3. Foreign Data Wrappers (FDW)

  1. Appendix Install, Hosting, and Command-Line Guides

    1. Installation Guides and Distributions

    2. Where to Host PostgreSQL

    3. PostgreSQL Packaged Command-Line Tools