- db.conf.php
$dbconfig['dev'] = array('localhost', 'dbname', 'username', 'password', 'pgsql', false); //do not to use persistent connections to test
- additional configurations
//The right way
Add it on app/index.php
Tip: See reason in http://www.doophp.com/doc/guide/basic/mvc. Because you must have been wondering
....
Doo::db()->setDb($dbconfig, $config['APP_MODE']);
Doo::db()->sql_tracking = true;
//CHANGE DATABASE SCHEMA
$st = Doo::db()->query('SET search_path TO myschema');
//CHANGE DATABASE CLIENT CHARSET
$st = Doo::db()->query("SET NAMES 'utf8'"); //View http://www.postgresql.org/docs/8.2/stat ... ibyte.html
//TEST - Not add!!
$st = Doo::db()->query('select * from mytable');
$result = $st->fetch(PDO::FETCH_ASSOC);
var_dump($result);
//END Test
....
Doo::app()->route = $route;
Doo::app()->run();
//Unfriendly way!!! not recommended!!!!
Add a table name with _table=myschema.mytable in the model "MyTable"
