app/django/db/backends/postgresql/version.py
author Pawel Solyga <Pawel.Solyga@gmail.com>
Tue, 02 Jun 2009 19:17:46 +0200
changeset 2379 1555814edac7
parent 323 ff1a9aa48cfd
permissions -rw-r--r--
Small changes in #extra_left, #extra_right tags in css file. Google Maps and Student Project List on Organization home page now doesn't lay on page footer if too high.

"""
Extracts the version of the PostgreSQL server.
"""

import re

VERSION_RE = re.compile(r'PostgreSQL (\d+)\.(\d+)\.')

def get_version(cursor):
    """
    Returns a tuple representing the major and minor version number of the
    server. For example, (7, 4) or (8, 3).
    """
    cursor.execute("SELECT version()")
    version = cursor.fetchone()[0]
    major, minor = VERSION_RE.search(version).groups()
    return int(major), int(minor)