I have a database table with texts where characters with diacritics are represented using Unicode escape sequences. For example: the text which would normally read nezjištěno is represented as nezjiu0161tu011Bno.

In PostgreSQL, I can do: SELECT E'nezjiu0161tu011Bno'; and it will return the correct human-readable representation of the string literal. I would like to do the same thing as the “E” switch does, but when selecting data from table, is that possible to do?