The most amazing Postgres feature: Transactional schema changes. Create tables, alter tables, insert data, all inside a transaction. If any step fails, everything is rolled back!

This blew my mind when I switched from MySQL (which doesn't even support transactions for inserts/updates in most engines).