Re: Changing the concept of a DATABASE

On Tue, May 22, 2012 at 12:00 PM, Susanne Ebrecht
<susanne@2ndquadrant.com> wrote:
> Usually you want to set the collation once per language schema. E.g. schema
> russian gets Russian collation and schema British gets British collation and
> so on.
>
> CREATE SCHEMA foo LC_COLLATE bar isn't supported so you went up a level and
> do it by creating a database.
>
> I would like to get default collation per schema / table in 9.2 or 9.3 but
> that is my personal
> wish,

Interesting idea.  Sort of like ALTER DEFAULT PRIVILEGES.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company