Hard psycopg2 dependency is still breaking pypy

[fake-name]

Effectively the issue as commented in #19 (comment) This package is broken for environments that use alternative postgres DB adapters (psycopg2cffi, pg8000).

I'm rolling updates to my requirements for various project, and this is still happening.

[bchopson]

If you can upgrade to SQLAlchemy 2.0.7, CITEXT has been added to the postgresql dialect:
https://docs.sqlalchemy.org/en/20/dialects/postgresql.html#sqlalchemy.dialects.postgresql.CITEXT

I can't speak to the compatibility with other adapters/pypy.