[horde] Postgresql

[Rod K]

On 4/22/2013 7:49 AM, lst_hoe02 at kwsoft.de wrote:
>
> Zitat von Michael M Slusarz <slusarz at horde.org>:
>
>> Quoting Rod K <horde at 23net.net>:
>>
>>> Sorry if this is documented somewhere. I searched but of course the 
>>> "schema" term turns up talk about DB structure.
>>>
>>> What I'm interested in learning is if there is an easy way to get 
>>> Horde to use a database schema other than the public schema when 
>>> using Postgres?  I have an extensive database for managing our 
>>> business including email and need to have Horde connect to the same 
>>> database as I will be needing to create views that will use some of 
>>> the Horde tables AND some of the existing tables.  And also provide 
>>> an easy way to clean up user data from Horde when their accounts are 
>>> deleted in the rest of the system.
>>
>> You almost certainly will need to make changes locally to the Horde 
>> code the modify the SQL queries.
>>
>> michael
>
> Another way would be to alter the default schema of the Horde DB-User, 
> no? From what i remember creating a schema named as the DB-user and 
> owned by this user would set this schema as default for every SQL 
> operation not using a schema setting at all.
>
> Regards
>
> Andreas
>
>
Andreas, thanks!  Can't believe I wasn't aware of that after all these 
years using Postgres.