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)

1 files changed, 25 insertions, 0 deletions

diff --git a/src/include/version.h.in b/src/include/version.h.in
new file mode 100644
index 00000000000..c0b0b00294e
--- /dev/null
+++ b/src/include/version.h.in
@@ -0,0 +1,25 @@
+/*-------------------------------------------------------------------------
+ *
+ * version.h.in--
+ *	  this file contains the interface to version.c.
+ *	  Also some parameters.
+ *
+ * $Header: /cvsroot/pgsql/src/include/Attic/version.h.in,v 1.1 1998/04/29 12:39:21 scrappy Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+#ifndef VERSION_H
+#define VERSION_H
+
+void ValidatePgVersion(const char *path, char **reason_p);
+void SetPgVersion(const char *path, char **reason_p);
+
+#define PG_RELEASE		"6"
+#define PG_VERSION		"3"
+#define PG_SUBVERSION	"2"
+
+#define PG_VERFILE		"PG_VERSION"
+
+#define PG_VERSION_STR  "PostgreSQL " ## PG_RELEASE ## "." ## PG_VERSION ## "." ## PG_SUBVERSION ## " on @host@, compiled by @CC@ @CC_VERSION@"
+
+#endif