summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql/version.py
diff options
context:
space:
mode:
Diffstat (limited to 'django/db/backends/postgresql/version.py')
-rw-r--r--django/db/backends/postgresql/version.py18
1 files changed, 18 insertions, 0 deletions
diff --git a/django/db/backends/postgresql/version.py b/django/db/backends/postgresql/version.py
new file mode 100644
index 0000000000..e14d791b07
--- /dev/null
+++ b/django/db/backends/postgresql/version.py
@@ -0,0 +1,18 @@
+"""
+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)
+