'Multiple schema postgre in codeigniter
i'm trying connect postgre other than public schema using codeigniter 3. i have following code :
$db['default']['hostname'] = "localhost";
$db['default']['port'] = "5432";
$db['default']['username'] = "postgres";
$db['default']['password'] = "12345";
$db['default']['database'] = "db_new";
$db['default']['dbdriver'] = "postgre";
$db['default']['schema'] = 'warehouse';
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
$db['default']['swap_pre'] = "";
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
when I try to run the application, it doesn't even connect to the database. Does codeigniter not support connections between schemas in postgre?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
