1. Home
  2. SQL
  3. Postgresql

Summary

This chapter has given you a gentle introduction to PostgreSQL. You have seen how to install PostgreSQL on your system and how to configure it for use. You've also created a sample database that you'll use throughout the rest of this book.

In the next chapter, I'll discuss the many PostgreSQL data types in more depth, and I'll give you some guidelines for choosing between them.



    		Part I: General PostgreSQL Use
    		Chapter 1. Introduction to PostgreSQL and SQL
    		A Sample Database
    		Basic Database Terminology
    		Prerequisites
    		Connecting to a Database
    		Creating Tables
    		Viewing Table Descriptions
    		Adding New Records to a Table
    		Installing the Sample Database
    		Retrieving Data from the Sample Database
    		Aggregates
    		Multi-Table Joins
    		UPDATE
    		DELETE
    		A (Very) Short Introduction to Transaction Processing
    		Using VIEW
    		Summary
    		Creating New Tables Using CREATE TABLE...AS
    		Chapter 2. Working with Data in PostgreSQL
    		Chapter 3. PostgreSQL SQL Syntax and Use
    		Chapter 4. Performance
    		Part II: Programming with PostgreSQL
    		Part III: PostgreSQL Administration