From: Jeroen van Vianen <jeroenv@design.nl>

Attached patch will add a version() function to Postges, e.g.

template1=> select version();
version
------------------------------------------------------------
PostgreSQL 6.3.2 on i586-pc-linux-gnu, compiled by gcc 2.8.1
(1 row)

2 files changed, 30 insertions, 2 deletions

diff --git a/src/backend/utils/adt/Makefile b/src/backend/utils/adt/Makefile
index cd338b34bf6..376be853077 100644
--- a/src/backend/utils/adt/Makefile
+++ b/src/backend/utils/adt/Makefile
@@ -4,7 +4,7 @@
 #    Makefile for utils/adt
 #
 # IDENTIFICATION
-#    $Header: /cvsroot/pgsql/src/backend/utils/adt/Makefile,v 1.12 1998/04/06 00:26:19 momjian Exp $
+#    $Header: /cvsroot/pgsql/src/backend/utils/adt/Makefile,v 1.13 1998/04/29 12:38:01 scrappy Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -22,7 +22,7 @@ OBJS = acl.o arrayfuncs.o arrayutils.o bool.o cash.o char.o chunk.o date.o \
 	misc.o nabstime.o name.o not_in.o numutils.o oid.o \
 	oidname.o oidint2.o oidint4.o oracle_compat.o regexp.o regproc.o  \
 	selfuncs.o \
-	tid.o varchar.o varlena.o sets.o datetime.o like.o timestamp.o
+	tid.o varchar.o varlena.o sets.o datetime.o like.o timestamp.o version.o
 
 all: SUBSYS.o
 
diff --git a/src/backend/utils/adt/version.c b/src/backend/utils/adt/version.c
new file mode 100644
index 00000000000..e0af6b2d6df
--- /dev/null
+++ b/src/backend/utils/adt/version.c
@@ -0,0 +1,28 @@
+/*-------------------------------------------------------------------------
+ *
+ * version.c--
+ *   Returns the version string
+ *
+ * IDENTIFICATION
+ *
+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/version.c,v 1.1 1998/04/29 12:38:05 scrappy Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#include "postgres.h"
+#include "version.h"
+
+
+text*  version(void);
+
+text*  version(void)
+{
+	int  n = strlen(PG_VERSION_STR) + VARHDRSZ;
+	text  *ret = (text *) palloc(n);
+
+	VARSIZE(ret) = n;
+	strcpy(VARDATA(ret), PG_VERSION_STR);
+
+	return ret;
+}