Hacker News Reader

In all honesty, you don't need a book on postgres. They have excellent documentation on their site

This one was super useful for me

https://www.amazon.es/PostgreSQL-High-Performance-Gregory-Sm...

I think that they have a newer edition for postgres 10

You don't go from zero to mastery in one book. Three years minimum, double or triple that if you're doing other stuff as well.

To start, Stepháne Faroult's SQL Success will give you a solid grounding in using RDBMSes as an application programmer. It's not Postgres specific, but the learning you need to do isn't tied to one vendor.

But as sibling said, you'll be using the documentation as well. PostgreSQL has documentation that is nearly up to the standards that hardware engineers expect and rely on.

Adding to the above, Schönig's Mastering PostgreSQL 11 will help you advance from intermediate to high-intermediate PostgreSQL programmer, as will Faroult's The Art of SQL. Karwin's SQL Antipatterns is useful supplementary reading also.

I've looked through my kindle, and I wouldn't bother with much else.

Not sure about “0” but https://theartofpostgresql.com is a good book.