How To Install Psycopg2 On Your Computer/Server

Pyscopg2 in a PostgresSQL adapter for the python programming language. As a DBAPI, it helps to simplify the task of database queries and management. With psycopg2, you could directly query and manage your database right from from the python programming interface.

Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent “INSERT”s or “UPDATE”s.

Psycopg 2 is mostly implemented in C as a libpq wrapper, resulting in being both efficient and secure. It features client-side and server-side cursors, asynchronous communication and notifications, “COPY TO/COPY FROM” support. Many Python types are supported out-of-the-box and adapted to matching PostgreSQL data types; adaptation can be extended and customized thanks to a flexible objects adaptation system.

Psycopg 2 is both Unicode and Python 3 friendly.

To install psycopg2, you'll need to have access to kernel. You'll also need to have python and latest version of pip installed. You'll also need PostgreSQL on your server or machine to create, run and manage your databases. Access the terminal, and from the terminal window, you'll type the following command.

$ pip install psycopg2

Hope that helps you to install Psycopg2 on your computer through the terminal?

For successful installation of psycopg2, make sure you've set a PATH in your bash_profile OR bashrc.