class.ilDBPostgreSQL.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */


include_once ("./Services/Database/classes/class.ilDB.php");

class ilDBPostgreSQL extends ilDB
{

        function getDSN()
        {
                return "pgsql://".$this->getDBUser().":".$this->getDBPassword()."@".
                        $this->getDBHost()."/".$this->getDBName();
        }

        function getDBType()
        {
                return "postgresql";
        }
        
        static function getReservedWords()
        {
                // version: 8.3.6
                // url: http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
                return array(
                        "ALL", "ANALYSE", "ANALYZE", "AND", "ANY", "ARRAY",
                        "AS", "ASC", "ASYMMETRIC", "AUTHORIZATION", "BETWEEN", "BINARY", "BOTH",
                        "CASE", "CAST", "CHECK", "COLLATE", "COLUMN", "CONSTRAINT", "CREATE",
                        "CROSS", "CURRENT_DATE", "CURRENT_ROLE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "CURRENT_USER", "DEFAULT",
                        "DEFERRABLE", "DESC", "DISTINCT", "DO", "ELSE", "END", "EXCEPT",
                        "FALSE", "FOR", "FOREIGN", "FREEZE", "FROM", "FULL", "GRANT",
                        "GROUP", "HAVING", "ILIKE", "IN", "INITIALLY", "INNER", "INTERSECT",
                        "INTO", "IS", "ISNULL", "JOIN", "LEADING", "LEFT", "LIKE",
                        "LIMIT", "LOCALTIME", "LOCALTIMESTAMP", "NATURAL", "NEW", "NOT", "NOTNULL",
                        "NULL", "OFF", "OFFSET", "OLD", "ON", "ONLY", "OR",
                        "ORDER", "OUTER", "OVERLAPS", "PLACING", "PRIMARY", "REFERENCES", "RETURNING",
                        "RIGHT", "SELECT", "SESSION_USER", "SIMILAR", "SOME", "SYMMETRIC", "TABLE",
                        "THEN", "TO", "TRAILING", "TRUE", "UNION", "UNIQUE", "USER",
                        "USING", "VERBOSE", "WHEN", "WHERE", "WITH"
                );
        }

        function initConnection()
        {
        }

        function now()
        {
                return "now()";
        }
        
        function supportsFulltext()
        {
                return false;
        }
        
        public function lockTables($a_tables)
        {
                return true;
        }
        
        public function unlockTables()
        {
                return true;
        }

}
?>