Install PostgreSQL client#
To connect to a PostgreSQL database from Python, you need a client library. We recommend using psycopg2
, but there are others like pg8000
, and asyncpg
. JupySQL supports the following connectors.
Installing psycopg2
#
The simplest way to install psycopg2
is with the following command:
pip install psycopg2-binary
If you have conda
installed, it is more reliable to use it:
conda install psycopg2 -c conda-forge
Installing pgspecial
#
Ensure that you are using pgspecial 1.x
. pgspecial 2.x
has migrated to psycopg3
and thus does not yield informative error messages.
conda install "pgspecial<2" -c conda-forge
If you have trouble getting it to work, message us on Slack.