我正在将一个postgres表作为json提取。输出文件包含如下行:
{"data": {"test": 1, "hello": "I have \" !"}, "id": 4}
现在我需要使用json.loads
在我的Python代码中加载它们,但是我遇到了这个错误:
Traceback (most recent call last):
File "test.py", line 33, in <module>
print json.loads('''{"id": 4, "data": {"test": 1, "hello": "I have \" !"}}''')
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/__init__.py", line 338, in loads
return _default_decoder.decode(s)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/decoder.py", line 365, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/decoder.py", line 381, in raw_decode
obj, end = self.scan_once(s, idx)
ValueError: Expecting , delimiter: line 1 column 50 (char 49)
我发现解决方法是在\"
中再添加一个\
。所以,如果我传递以下内容:{"data": {"test": 1, "hello": "I have \\" !"}, "id": 4}
使用json.loads
,我得到了这个:
{u'data': {u'test': 1, u'hello': u'I have " !'}, u'id': 4}
有没有不添加额外\
的方法?比如通过将参数传递给json.loads
之类的方式?