<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /** * Code Igniter * * An open source application development framework for PHP 4.3.2 or newer * * @package CodeIgniter * @author Rick Ellis * @copyright Copyright (c) 2006, pMachine, Inc. * @license http://www.codeignitor.com/user_guide/license.html * @link http://www.codeigniter.com * @since Version 1.0 * @filesource */ // ------------------------------------------------------------------------ /** * Postgre Utility Class * * @category Database * @author Rick Ellis * @link http://www.codeigniter.com/user_guide/database/ */ class CI_DB_postgre_utility extends CI_DB_utility { /** * Create database * * @access private * @param string the database name * @return bool */ function _create_database($name) { return "CREATE DATABASE ".$name; } // -------------------------------------------------------------------- /** * Drop database * * @access private * @param string the database name * @return bool */ function _drop_database($name) { return "DROP DATABASE ".$name; } // -------------------------------------------------------------------- /** * List databases * * @access private * @return bool */ function _list_databases() { return "SELECT datname FROM pg_database"; } // -------------------------------------------------------------------- /** * Drop Table * * @access private * @return bool */ function _drop_table($table) { return "DROP TABLE ".$this->db->_escape_table($table)." CASCADE"; } // -------------------------------------------------------------------- /** * Optimize table query * * Is table optimization supported in Postgre? * * @access private * @param string the table name * @return object */ function _optimize_table($table) { return FALSE; } // -------------------------------------------------------------------- /** * Repair table query * * Are table repairs supported in Postgre? * * @access private * @param string the table name * @return object */ function _repair_table($table) { return FALSE; } // -------------------------------------------------------------------- /** * Postgre Export * * @access private * @param array Preferences * @return mixed */ function _backup($params = array()) { // Currently unsupported return $this->db->display_error('db_unsuported_feature'); } } ?>