Simple PostgreSQL queries from Python

How can you connect to a PostgreSQL database, and then query it, from Python? I show the basics here, in this video. For more Python tips, tricks, and understanding, check out my free, weekly “Better developers” newsletter, at http://lerner.co.il/newsletter/ .