Allow choosing a Psycopg implementation, add support for psycopg2cffi.

Centralize code that detects available Psycopg implementations.  A particular
implementation can now be forced using an environment variable.

A new fallback option, psycopg2cffi, has been added.

Fixes #30.