I want to connect Drupal to an external Database and I need to specify the schema on the settings.php file, otherwise Drupal schema module connects by default to the ‘public’ schema. I tried, without success, with the following code.
$databases['conservation']['default'] = array(
'database' => 'conservation',
'schema' => 'projects_test1',
'username' => 'xxxxxxxxxxx',
'password' => 'xxx',
'host' => 'xxx.xxx.xxx',
'port' => '5432',
'driver' => 'pgsql',
'prefix' => array(
'default' => 'projects_test1.',
'users' => 'shared.',
'sessions' => 'shared.',
'role' => 'shared.',
'authmap' => 'shared.',
)
);
I have done some googling, but I haven’t found anybody trying to do this.