David Gauthier <davegauthierpg@xxxxxxxxx> writes: > Next question, how does one actually replace the thing ? > replace(thestring,0x2026,'...') > ... isn't going to fly. If you don't want to write the actual UTF8 character, maybe the chr() function would suit you better [1]. regards, tom lane [1] https://www.postgresql.org/docs/current/functions-string.html