On fre, 2011-12-23 at 17:32 +0200, Andrus wrote: > >If you don't want to re-initdb, you could just update the datctype and > >datcollate columns of pg_database for template0. > > Thank you. > where to find sql update statement which does this ? > Is > > update pg_database set datctype ='et_EE.UTF-8', datcollate ='et_EE.UTF-8' > > best for this ?
add WHERE datname = 'template0' > template0 is read-only, how to connect to and update it using pgAdmin ? pg_database is shared between all databases, so you can connect to any database to do this. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
