On Thursday 16 July 2009 10:53:37 Massa, Harald Armin wrote: > Hello, > > I have an old PostgreSQL Database which was created with encoding = > SQL_ASCII. That is an old sin of mine; 9years ago I did not know better. > > Now I know better than to use SQL_ASCII. > > On the bright side: I am totally sure that the TEXT within that database is > in WIN1252 / CP1252 encoding. > > Is there any way to overwrite the encoding-information? something like > "udpate <specialsystemcatalog> set pg_encodingcol='xxx' where > databasename='oldsin'; Would a dump+reload work? Andres -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
