soci-postgresql contains SOCI core and the implementation of PostgreSQL backend.
conda install conda-forge::soci-postgresql