author | Pawel Solyga <Pawel.Solyga@gmail.com> |
Sun, 05 Jul 2009 12:18:31 +0200 | |
changeset 2544 | 8f3a8e066111 |
parent 323 | ff1a9aa48cfd |
permissions | -rw-r--r-- |
""" 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)