I have encoded values in the table, and wanted to select them as a plain text without altering the database property,
I have tried many ways, but not getting exact result.
Value - Er tręäńgt keinen Manteł
Expected - Er treangt keinen Mantel
SELECT 'Er tręäńgt keinen Manteł', 'Er tręäńgt keinen Manteł'::bytea;
SELECT 'Er tręäńgt keinen Manteł', convert_to('Er tręäńgt keinen Manteł', 'utf-8');
Any suggestion will be helpful.