擅长:python、mysql、java
<p>嗯,但我不想像<code>json.loads()</code>那样做三次往返,传递给SQLAlchemy,后者会执行<code>json.dumps()</code>,然后Postgres会再次进行解组。在</p>
<p>因此,我创建了一个元数据表,将jsonb列类型指定为Text。现在我获取我的json字符串,SQLALchemy传递它们,Postgres将它们存储为jsonb对象。在</p>
<pre><code>import sqlalchemy as sa
metadata = sa.MetaData()
rawlog = sa.Table('rawlog', metadata, sa.Column('document', sa.Text)
with create_engine("postgresql:///mydb") as engine:
with engine.acquire() as conn:
conn.execute(rawlog.insert().values(document=document)
</code></pre>
<p>其中document是字符串,而不是python对象。在</p>