Skip to main content

A psycopg2 wrapper trying to make your job easier.

Project description


Build Status

pip3 install pypostgres

Not tested in python 2.x

Basic usage

Just connect to your db using Postgres class and pass the queries to .query() method.

The .query() method will return a custom Cursor class, if you don’t want nothing back from the db, you don’t need to store it but if you want to fetch any data, you can do it whenever you want because the Cursor class will always handle the real connection with the db. In other words you will never need to worry about closed cursors or connections because only at the exact time you request data from db the Cursor class opens the connection and then it closes it.

>>> from pypostgres.postgres import Postgres

# Database connection
>>> db = Postgres(database='books', user='john')
>>> cursor = db.query('SELECT author FROM books;')
('George R. R. Martin',)
>>> cursor.all
[('George R. R. Martin',), ('J. R. R. Tolkien',)]

Postgres class

  1. mogrify: psycopg2.cursor.mogrify()
  2. query: return Cursor object for given sql statements and (optional) values
  3. get_columns: return table columns
  4. get_tables: return all tables in current db
  5. get_databases: return all dbs in current connectino

Cursor class

If you are SELECTing data, the Cursor object can help you fetch that data. You have two options:


  1. return one result
  2. Cursor.all: return all results
  3. Cursor.many(n) (actually a method): return n results

Fetch method

Just pass how many result you want e.g. .fetch(n):

  1. 1 or one for one
  2. 0, * or all for all
  3. An int for other values

Cursor factory

I consider the task of handling fechted data very important so I gave a special attention to cursor factory.

All Postgres class methods (except .mogrify()) accept a cursor_factory param that handle the desired cursor factory. For each type of cursor factory you can pass different things to get the same factory, see below.


For namedtuple results, you can pass:

  1. ‘NamedTuple’, str
  2. ‘NamedTupleCursor’, str
  3. namedtuple, function from collections
  4. psycopg2.extras.NamedTupleCursor, the actual cursor factory


For dict results, you can pass:

  1. ‘Dict’, str
  2. ‘Dictursor’, str
  3. dict, type
  4. psycopg2.extras.DictCursor, the actual cursor factory


For RealDict results, you can pass:

  1. ‘RealDict’, str
  2. ‘RealDictursor’, str
  3. psycopg2.extras.RealDictCursor, the actual cursor factory

Connection class as contextmanager

The Connection class handle the entrance and exit of the database connection, opening the communication when you entered it and closing the connection when you are out.

>>> from pypostgres.connection import Connection
>>> dsn = 'dbname=books user=john'
>>> with Connection(dsn=dsn) as conn:
>>>     # do whatever you want to do
>>>     cursor = conn.cursor()
>>>     cursor.execute('SELECT author, book FROM books;')
>>>     data = cursor.fetchone()
>>> data
('C. S. Lewis', 'The Chronicles of Narnia')

Project details

Release history Release notifications

This version
History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
pypostgres-0.8.2.tar.gz (17.7 kB) Copy SHA256 hash SHA256 Source None Jun 21, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page