valgog wrote:
I know it looks like a mess
Indeed, that is what client encoding is for :)
> One idea is to write the function, that will normalize the data to
> UTF-8 in PL/pgSQL (that I could not do from the first try)
You could use convert(), iterate over the rows and catch the exceptions
in pl/pgsql.
http://www.postgresql.org/docs/8.3/interactive/functions-string.html
http://www.postgresql.org/docs/8.3/interactive/plpgsql-control-structures.html
--
Best regards,
Hannes Dorbath