cursor.execute("""INSERT INTO customer(id, name) 
    VALUES( %s, %s)""" % (id, name))


Gives:

Connecting...
Customer ID: 100001
Customer name: Hest Inc.
Creating new customer(id=100001; name='Hest Inc.')
Traceback (most recent call last):
  File "soho-create-customer.py", line 23, in <module>
    VALUES( %s, %s)""" % (id, name))
psycopg2.ProgrammingError: syntax error at or near "Inc"
LINE 2:     VALUES( 100001, Hest Inc.)