Fork me on GitHub
#sql
<
2018-07-27
>
mpenet15:07:40

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

mpenet15:07:53

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.