"Henry C." <henka@xxxxxxxxxxxxx> writes: > Anyway, thanks for the feedback. Ok, so it's simply a case of: > update pg_database set datcollate='C', datctype='C'; > Correct? Mine are all POSIX, so no where clause needed. Yeah, that should do it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general