hello, moving from mongo to postgres, I get byte s...
# troubleshootingm
mert_bakir
05/24/2023, 8:27 PMhello, moving from mongo to postgres, I get byte string representation for UUID datatypes like this:
b'\xab\xb3\x89"\x06\x80C6\x96\xd4&\xa3\x1fA\xc9~'abb389220680433696d426a31f41c97efoo.hex()mert_bakir
05/24/2023, 8:39 PMthis is what I have as text
c
ceyhun_kerti
05/24/2023, 9:34 PM Copy code
SELECT encode(E'\xab\xb3\x89"\x06\x80C6\x96\xd4&\xa3\x1fA\xc9~', 'hex');m
mert_bakir
05/24/2023, 9:40 PMSELECT encode(E'\xab\xb3\x89"\x06\x80C6\x96\xd4&\xa3\x1fA\xc9~', 'hex');ERROR: invalid byte sequence for encoding "UTF8": 0xab