1 files changed, 58 insertions, 0 deletions
diff --git a/framework/db/schema/pgsql/CPgsqlColumnSchema.php b/framework/db/schema/pgsql/CPgsqlColumnSchema.php
new file mode 100644
index 0000000..45b6f56
--- /dev/null
+++ b/framework/db/schema/pgsql/CPgsqlColumnSchema.php
@@ -0,0 +1,58 @@
+<?php
+/**
+ * CPgsqlColumnSchema class file.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2011 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+/**
+ * CPgsqlColumnSchema class describes the column meta data of a PostgreSQL table.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id: CPgsqlColumnSchema.php 2799 2011-01-01 19:31:13Z qiang.xue $
+ * @package system.db.schema.pgsql
+ * @since 1.0
+ */
+class CPgsqlColumnSchema extends CDbColumnSchema
+{
+	/**
+	 * Extracts the PHP type from DB type.
+	 * @param string $dbType DB type
+	 */
+	protected function extractType($dbType)
+	{
+		if(strpos($dbType,'[')!==false || strpos($dbType,'char')!==false || strpos($dbType,'text')!==false)
+			$this->type='string';
+		else if(strpos($dbType,'bool')!==false)
+			$this->type='boolean';
+		else if(preg_match('/(real|float|double)/',$dbType))
+			$this->type='double';
+		else if(preg_match('/(integer|oid|serial|smallint)/',$dbType))
+			$this->type='integer';
+		else
+			$this->type='string';
+	}
+
+	/**
+	 * Extracts the default value for the column.
+	 * The value is typecasted to correct PHP type.
+	 * @param mixed $defaultValue the default value obtained from metadata
+	 */
+	protected function extractDefault($defaultValue)
+	{
+		if($defaultValue==='true')
+			$this->defaultValue=true;
+		else if($defaultValue==='false')
+			$this->defaultValue=false;
+		else if(strpos($defaultValue,'nextval')===0)
+			$this->defaultValue=null;
+		else if(preg_match('/^\'(.*)\'::/',$defaultValue,$matches))
+			$this->defaultValue=$this->typecast(str_replace("''","'",$matches[1]));
+		else if(preg_match('/^-?\d+(\.\d*)?$/',$defaultValue,$matches))
+			$this->defaultValue=$this->typecast($defaultValue);
+		// else is null
+	}
+}