Re: [GENERAL] Removing null bytes from a json column

2017-06-11 Thread Tom Lane
Timothy Garnett writes: > Does anyone have some tips on how to deal with an existing json type column > that has some null bytes ( \u) in it? It seems like anything I do that > touches any row with a null byte just errors. I'd love to just remove them > if I could find some way to find them,

[GENERAL] Removing null bytes from a json column

2017-06-10 Thread Timothy Garnett
Does anyone have some tips on how to deal with an existing json type column that has some null bytes ( \u) in it? It seems like anything I do that touches any row with a null byte just errors. I'd love to just remove them if I could find some way to find them, but I'm having trouble even figur