DBAPI Support¶ The following dialect/DBAPI options are available. Please refer to individual DBAPI sections for connect information. psycopg2 psycopg (a.k.a. psycopg 3) pg8000 asyncpg psycopg2cffi Sequences/SERIAL/IDENTITY¶ PostgreSQL supports sequences, and SQLAlchemy uses these as the default means of creating new primary key values for integer-based primary key columns. When creating tables, SQ