Fork me on GitHub

How do you folks deal with pg issues with null bytes in strings (also in jsonb)?


We have lots of ext data so I can't ensure the content is safe and I'd like to avoid to parse fields/walk entire jsonb structures all the time (this pb happens quite rarely). I am tempted to sanitize&retry upon failure but that feels a bit dirty, I am wondering if there's not a better solution.