PYTHON CONNECT TO POSTGRESQL MAC OS X

The library is also available on MacPorts try : sudo port install py27-psycopg2 Psycopg is available as a fink package in the unstable tree: you may install it with: fink install psycopg2-py27 On Debian, Ubuntu and other deb-based distributions execute the following command to install the package with all its dependencies.

PYTHON CONNECT TO POSTGRESQL MAC OS X

Python comes preloaded on many Linux distribution or Unix-like systems, such as Mac OS X and FreeBSD. The python connector runs on any platform where Python is installed. Can send and receiveВ asynchronous notification.

Extendible withВ new adaptersВ to convert Python objects to SQL syntax and type castersВ to convert PostgreSQL types back into Python objects.

AdaptationВ of many Python objects to database type: tuples to records, lists to an array, dictionaries to hstore, flexible JSON support.

Asynchronous nonblocking I/O also integrated withВ coroutine-based libraries.

Thread-safe: threads can use different connections or share the same connection.

Fully compliant implementation of the PythonВ DB API specificationВ for database adapters.

Supports PostgreSQL versions from 7.4 to 9.4.

Supports Python versions from 2.5 to 3.4.

Psycopg is written mostly in C and wraps the libpq library with the result of being both fast and secure. Psycopg is released under the terms of the GNU Lesser General Public License, allowing use of both free and proprietary software.

Several extensions allow access to many of the features offered by PostgreSQL. At its core, it fully implements the Python DB API 2.0 specifications.

Psycopg is the most popular PostgreSQL adapter for the Python programming language.

Python connect to postgresql