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.
- 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
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
psqlcommands list