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 and SQL in general.

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. 68 - Deleting Tables When a table is dropped, its sequence relations are also deleted so there's no need to delete them manually.
• pg. 69 - Populating Tables

4. Accessing Your Data

This entire chapter is devoted to the SELECT statement.

• pg. 74 - Connecting to PostgreSQL using psql.exe
• pg. 75 - Connecting to a remote server.
• pg. 78 - Essential psql commands list
• pg. 87 - Standard comparison operators
• pg. 94 - PostgreSQL Date/Time formatting (ISO-8601, YYYY-MM-DD hh:mm:ss.ssTZD)
• pg. 99 - Extracting parts of a date (year, month, day, hour, minute, second)
• pg. 103 - Relating two tables
• pg. 105-106 - Aliasing table names
• pg. 106 - Relating three or more tables.
• pg. 111 - SQL92 JOIN syntax

5. PostgreSQL Command-Line and Graphical Tools

• pg. 118 - psql Command-Line Quick Reference
• pg. 119 - psql Internal Commands Quick Reference

6. Data Interfacing