1. Home
  2. SQL
  3. Postgresql

Summary

Chapter 1, "Introduction to PostgreSQL and SQL," showed you some of the basics of retrieving and modifying data using PostgreSQL. In Chapter 2, "Working with Data in PostgreSQL," you learned about the many data types offered by PostgreSQL. This chapter has filled in some of the scaffolding?you've seen how to create new databases, new tables, and new indexes. You've also seen how PostgreSQL solves concurrency problems through its multi-versioning transaction model.

The next chapter, Chapter 4, "Query Optimization," should help you understand how the PostgreSQL server decides on the fastest way to execute your SQL commands.



    		Part I: General PostgreSQL Use
    		Chapter 1. Introduction to PostgreSQL and SQL
    		Chapter 2. Working with Data in PostgreSQL
    		Chapter 3. PostgreSQL SQL Syntax and Use
    		PostgreSQL Naming Rules
    		Creating, Destroying, and Viewing Databases
    		Creating New Tables
    		Adding Indexes to a Table
    		Getting Information About Databases and Tables
    		Transaction Processing
    		Summary
    		Chapter 4. Performance
    		Part II: Programming with PostgreSQL
    		Part III: PostgreSQL Administration