Connecting to a postgresql DB?

[Lance Hoffmeyer]

Hello,

I am trying to learn some basics of python.  One of the things
I want to do is write a script to access a postgresql database
DB as user USER with password PW and 

SELECT first_name, last_name, birthday FROM contacts

print to the screen and then disconnect.


Can someone show me an example of how to do this?

Lance