1 <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
\r
5 * An open source application development framework for PHP 4.3.2 or newer
\r
7 * @package CodeIgniter
\r
8 * @author ExpressionEngine Dev Team
\r
9 * @copyright Copyright (c) 2008, EllisLab, Inc.
\r
10 * @license http://codeigniter.com/user_guide/license.html
\r
11 * @link http://codeigniter.com
\r
12 * @since Version 1.0
\r
16 // ------------------------------------------------------------------------
\r
19 * Postgre Utility Class
\r
21 * @category Database
\r
22 * @author ExpressionEngine Dev Team
\r
23 * @link http://codeigniter.com/user_guide/database/
\r
25 class CI_DB_postgre_utility extends CI_DB_utility {
\r
33 function _list_databases()
\r
35 return "SELECT datname FROM pg_database";
\r
38 // --------------------------------------------------------------------
\r
41 * Optimize table query
\r
43 * Is table optimization supported in Postgre?
\r
46 * @param string the table name
\r
49 function _optimize_table($table)
\r
54 // --------------------------------------------------------------------
\r
57 * Repair table query
\r
59 * Are table repairs supported in Postgre?
\r
62 * @param string the table name
\r
65 function _repair_table($table)
\r
70 // --------------------------------------------------------------------
\r
76 * @param array Preferences
\r
79 function _backup($params = array())
\r
81 // Currently unsupported
\r
82 return $this->db->display_error('db_unsuported_feature');
\r
87 * The functions below have been deprecated as of 1.6, and are only here for backwards
\r
88 * compatibility. They now reside in dbforge(). The use of dbutils for database manipulation
\r
89 * is STRONGLY discouraged in favour if using dbforge.
\r
97 * @param string the database name
\r
100 function _create_database($name)
\r
102 return "CREATE DATABASE ".$name;
\r
105 // --------------------------------------------------------------------
\r
111 * @param string the database name
\r
114 function _drop_database($name)
\r
116 return "DROP DATABASE ".$name;
\r
123 /* End of file postgre_utility.php */
\r
124 /* Location: ./system/database/drivers/postgre/postgre_utility.php */