擅长:python、mysql、java
<p>您需要为python和postgres注册UUID类型以推断类型</p>
<pre class="lang-py prettyprint-override"><code>
import psycopg2.extras
psycopg2.extras.register_uuid()
sql = """
SELECT
id,
array_agg(еnty_pub_uuid) AS ptr_entity_public
FROM table
GROUP BY id
"""
cursor = con.cursor()
cursor.execute(sql)
results = cursor.fetchall()
for r in results:
print(type(r[1]))
</code></pre>