Improve DB field_data() for PostgreSQL
diff --git a/system/database/drivers/mssql/mssql_driver.php b/system/database/drivers/mssql/mssql_driver.php
index e081de4..faa1e26 100644
--- a/system/database/drivers/mssql/mssql_driver.php
+++ b/system/database/drivers/mssql/mssql_driver.php
@@ -346,7 +346,7 @@
{
return 'SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.Columns
- WHERE TABLE_NAME = '.$this->escape($table);
+ WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
}
// --------------------------------------------------------------------
@@ -366,7 +366,7 @@
$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.Columns
- WHERE TABLE_NAME = '.$this->escape($table);
+ WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
if (($query = $this->query($sql)) === FALSE)
{