On tis, 2012-05-22 at 18:00 +0200, Susanne Ebrecht wrote: > 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,
Another way I've been thinking about is to have a session collation. Then you don't have to decide about it when the tables are created, but the application or user interface can decide it at run time without having to hardcode it into all the queries. This would effectively take the place of being able to say SET lc_collate at run time. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
