Books & Videos

Table of Contents

  1. Introduction & Installation

    1. Chapter 1 What Is PostgreSQL?

      1. Open Source Free Version
      2. PostgreSQL Feature Set
      3. Where to Proceed from Here
    2. Chapter 2 Installing PostgreSQL

      1. Preparing for Installation
      2. 10 Steps to Installing PostgreSQL
  2. Using PostgreSQL

    1. Chapter 3 Understanding SQL

      1. Introduction to SQL
      2. Introduction to Relational Databases
      3. SQL Statements
      4. Data Types
      5. Tables in PostgreSQL
    2. Chapter 4 Using SQL with PostgreSQL

      1. Introduction to psql
      2. Using Tables
      3. Adding Data with INSERT and COPY
      4. Retrieving Rows with SELECT
      5. Modifying Rows with UPDATE
      6. Removing Rows with DELETE
      7. Using Sub-Queries
      8. Using Views
      9. Further SQL Application
    3. Chapter 5 Operators and Functions

      1. Operators
      2. Functions
    4. Chapter 6 PostgreSQL Clients

      1. The psql Client: Advanced Topics
      2. PgAccess: A Graphical Client
    5. Chapter 7 Advanced Features

      1. Indices
      2. Advanced Table Techniques
      3. Arrays
      4. Automating Common Routines
      5. Transactions and Cursors
      6. Extending PostgreSQL
  3. Administrating PostgreSQL

    1. Chapter 8 Authentication and Encryption

      1. Client Authentication
      2. Encrypting Sessions
    2. Chapter 9 Database Management

      1. Starting and Stopping PostgreSQL
      2. Initializing the Filesystem
      3. Creating and Removing a Database
      4. Maintaining a Database
      5. Backing Up and Restoring Data
    3. Chapter 10 User and Group Management

      1. Managing Users
      2. Managing Groups
      3. Granting Privileges
  4. PostgreSQL Programming

    1. Chapter 11 PL/pgSQL

      1. Adding PL/pgSQL to Your Database
      2. Language Structure
      3. Using Variables
      4. Controlling Program Flow
      5. PL/pgSQL and Triggers
    2. Chapter 12 JDBC

      1. Building the PostgreSQL JDBC Driver
      2. Using the PostgreSQL Driver
      3. Using JDBC
      4. Issues Specific to PostgreSQL and JDBC
    3. Chapter 13 LXP

      1. Why Use LXP?
      2. Core Features
      3. Installing and Configuring LXP
      4. Understanding LXP Mark-Up
      5. LXP Variables and Objects
      6. Using Cookies with LXP
      7. Tag Parsing
      8. Branching Logic
      9. Loop Iteration
      10. Content Inclusion
      11. Displaying Foreign Tags with <xtag>
  5. Command Reference

    1. Chapter 14 PostgreSQL Command Reference

      1. Abort
      2. Alter Group
      3. Alter Table
      4. Alter User
      5. Begin
      6. Close
      7. Cluster
      8. Comment
      9. Commit
      10. Copy
      11. Create Aggregate
      12. Create Database
      13. Create Function
      14. Create Group
      15. Create Index
      16. Create Language
      17. Create Operator
      18. Create Rule
      19. Create Sequence
      20. Create Table
      21. Create Table As
      22. Create Trigger
      23. Create Type
      24. Create User
      25. Create View
      26. Current_Date
      27. Current_Time
      28. Current_Timestamp
      29. Current_User
      30. Declare
      31. Delete
      32. Drop Aggregate
      33. Drop Database
      34. Drop Function
      35. Drop Group
      36. Drop Index
      37. Drop Language
      38. Drop Operator
      39. Drop Rule
      40. Drop Sequence
      41. Drop Table
      42. Drop Trigger
      43. Drop Type
      44. Drop User
      45. DROP VIEW
      46. End
      47. Explain
      48. FETCH
      49. Grant
      50. Insert
      51. Listen
      52. Load
      53. Lock
      54. Move
      55. Notify
      56. Reindex
      57. Reset
      58. Revoke
      59. Rollback
      60. Select
      61. Select Into
      62. Set
      63. Set Constraints
      64. Set Transaction
      65. Show
      66. Truncate
      67. Unlisten
      68. Update
      69. Vacuum
    2. Appendix Multibyte Encoding Types

    3. Appendix Backend Options for postgres

    4. Appendix Binary COPY Format

      1. The Header
      2. Tuples
      3. Trailer
    5. Appendix Internal psql Variables

  1. Appendix About the Authors

  2. Colophon