app/django/db/backends/postgresql/version.py
author Lennard de Rijk <ljvderijk@gmail.com>
Tue, 04 Aug 2009 21:46:03 +0200
changeset 2730 d1cfed8da027
parent 323 ff1a9aa48cfd
permissions -rw-r--r--
Redone the list_info function for the Project's manage page. This will reduce the overhead because Django calls the info method over and over again.

"""
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)