php - Set a non-default schema in Yii Framework with PostgreSQL -

I am using the Yii framework with PostgreSQL and I need to create new models in a non-default schema. How can I do that? I tried the following:

Protected / Component / PgSchemaConnection.php

  class PgSchemaConnection Extended CDbConnection {secure function initConnection ($ pdo) { Parents :: initConnection ($ PDO); $ Stmt = $ pdo- & gt; Prepare ("set search_path master, public"); $ Stmt- & gt; Executed (); }}  

protected / config / main.php

  return array (... 'db' = & gt; Array ('ConnectionString' = & gt; 'pgsql: host = localhost; dbname = bsc', 'username' = & gt; 'aUser', 'password' = & gt; 'apes', 'charset' => ; 'Utf8', 'class' = & gt; 'PgSchemaConnection'), ...)  

But when I run in the console

  Gt; & Gt; Model Fu WARNING: Database 'Foo' table does not exist. Model Generated / relatedobjective.php PHP Warning: For the foreach () supply invalid warnings for /home/cristhian/php_apps/yii-1.1.14.f0fee9/framework/cli/views/shell/model/fixture.php 13 PHP Warning: On line line / 19 / frank / Christian /php_apps/yii-1.1.14.f0fee9/framework/cli/views/shell/model/fixture.php for foreach () supply invalid logic / fixtures generated / relatedobjective .php generated unit / relatedobjectiveTest .php The following model classes have been successfully generated: relatedobjective If you have a 'db' database connection, Ladies can now test: $ model = relatedobjective :: model () - & gt; Find (); Print_r ($ models);  

The table Foo is not found in the Yii database (unfortunately, I have created the FU table)

How do I set up another schema? What am I doing wrong?

Just provide a complete path to your table - including the schema name.

With GII, I set the 'table name' field with the schema name 'qualified name'.

Your model will look like this:

  class MyModel extends CActiveRecord {... tableName () {return 'schemaName.tableName'; }  

This model will query with your default 'DB' connection config.