Beginning Databases with PostgreSQL

Beginning Databases with PostgreSQL

Although this book is concerned with PostgreSQL version 8 and its database design is questionable, it's still a pretty good source for learning Postgres.

Notes:

1. Introduction to PostgreSQL

2. Relational Database Principles

3. Getting Started with PostgreSQL

• pg. 55 - Creating Users (using the createuser.exe)
• pg. 66 - Creating Databases (using the createdb.exe)
• pg. 67 - Creating Tables
• pg. 67 - Running SQL scripts with \i inside the psql prompt
• pg. 68 - Deleting Tables
• pg. 69 - Populating Tables

4. Accessing Your Data