Learning PostgreSQL

Question

What's the best place to start learning PostgreSQL administration and programming in a Linux environment? What websites are the most recommended, concise and have easy to learn tutorials?

I am already familiar with ANSI SQL from playing with SQL Server and MySQL; however, I've never touched PostgreSQL before. Any direction you can give is appreciated.

Solution 1

I have found the documentation on the web for postgresql to be very high quality.

Solution 2

Having gone through this exact process about a year ago I found the following useful:

1. psql prompt is your friend.
2. The postgres online docs are great.
3. This postgres book was great for both admin and programing for postgres driven programs.

Solution 3

best way to learn to admin a database is to download it, install it, and start it up and work through the problems/questions as they happen.

download from: http://www.postgresql.org/

Once you have it up and running, pick a topic to learn and read up on that one topic. Move from topic to topic, until you can do everything you want to do.