title: How to define on Drupal an external database specifying the schema
body: <p>I want to connect Drupal to an external Database and i need to specify the schema otherwise Drupal schema module connects by default the 'public' schema. I tried, whithout succes with the following code:</p>
  
  <pre><code> $databases['conservation']['default'] = array(
       'database' =&gt; 'conservation',
       'schema' =&gt; 'projects_test1',
        'username' =&gt; 'xxxxxxxxxxx',
        'password' =&gt; 'xxx',
        'host' =&gt; 'xxx.xxx.xxx',
        'port' =&gt; '5432',
        'driver' =&gt; 'pgsql',
        'prefix' =&gt; array(
       'default'   =&gt; 'projects_test1.',
       'users'     =&gt; 'shared.',
       'sessions'  =&gt; 'shared.',
       'role'      =&gt; 'shared.',
       'authmap'   =&gt; 'shared.',
     )
  
  );
  </code></pre>
  
  <p>I have done some googling but haven't found anybody trying to do this as yet.
  Thanks
  Luca</p>