1 files changed, 104 insertions, 0 deletions
diff --git a/src/Database/Postgres92.php b/src/Database/Postgres92.php
new file mode 100644
index 00000000..41410da1
--- /dev/null
+++ b/src/Database/Postgres92.php
@@ -0,0 +1,104 @@
+<?php
+
+/**
+ * PHPPgAdmin6
+ */
+
+namespace PHPPgAdmin\Database;
+
+use PHPPgAdmin\Help\PostgresDoc92;
+
+/**
+ * @file
+ * PostgreSQL 9.2 support
+ */
+class Postgres92 extends Postgres93
+{
+    public $typIndexes = ['BTREE', 'RTREE', 'GIST', 'GIN', 'HASH'];
+
+    /**
+     * @var float
+     */
+    public $major_version = 9.2;
+
+    /**
+     * @var class-string
+     */
+    public $help_classname = PostgresDoc92::class;
+
+    /**
+     * Returns all available process information.
+     *
+     * @param null|string $database (optional) Find only connections to specified database
+     *
+     * @return \ADORecordSet|bool|int|string A recordset
+     */
+    public function getProcesses($database = null)
+    {
+        if (null === $database) {
+            $sql = "SELECT datname, usename, pid, waiting, state_change as query_start,
+                  case when state='idle in transaction' then '<IDLE> in transaction' when state = 'idle' then '<IDLE>' else query end as query
+				FROM pg_catalog.pg_stat_activity
+				ORDER BY datname, usename, pid";
+        } else {
+            $this->clean($database);
+            $sql = \sprintf(
+                'SELECT datname, usename, pid, waiting, state_change as query_start,
+                  case when state=\'idle in transaction\' then \'<IDLE> in transaction\' when state = \'idle\' then \'<IDLE>\' else query end as query
+				FROM pg_catalog.pg_stat_activity
+				WHERE datname=\'%s\'
+				ORDER BY usename, pid',
+                $database
+            );
+        }
+
+        return $this->selectSet($sql);
+    }
+
+    /**
+     * Retrieves information for all tablespaces.
+     *
+     * @param bool $all Include all tablespaces (necessary when moving objects back to the default space)
+     *
+     * @return \ADORecordSet|bool|int|string A recordset
+     */
+    public function getTablespaces($all = false)
+    {
+        $conf = $this->conf;
+
+        $sql = "SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, pg_catalog.pg_tablespace_location(oid) as spclocation,
+                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid AND pd.classoid='pg_tablespace'::regclass) AS spccomment
+					FROM pg_catalog.pg_tablespace";
+
+        if (!$conf['show_system'] && !$all) {
+            $sql .= ' WHERE spcname NOT LIKE $$pg\_%$$';
+        }
+
+        $sql .= ' ORDER BY spcname';
+
+        return $this->selectSet($sql);
+    }
+
+    // Misc functions
+
+    /**
+     * Retrieves a tablespace's information.
+     *
+     * @param string $spcname
+     *
+     * @return \ADORecordSet|bool|int|string A recordset
+     */
+    public function getTablespace($spcname)
+    {
+        $this->clean($spcname);
+
+        $sql = \sprintf(
+            'SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, pg_catalog.pg_tablespace_location(oid) as spclocation,
+                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid AND pd.classoid=\'pg_tablespace\'::regclass) AS spccomment
+					FROM pg_catalog.pg_tablespace WHERE spcname=\'%s\'',
+            $spcname
+        );
+
+        return $this->selectSet($sql);
+    }
+}