The PostgreSQL manual is pretty good and if you're going to use that database you'd better read it and then read it again and read it again.

See also this guy's books

https://www.amazon.com/stores/Joe-Celko/author/B000ARBFVQ?re...