擅长:python、mysql、java
<p>您可以做的另一件事是创建一个游标,您可以使用该游标按列的名称引用列(这是一种需要,让我首先进入本页):</p>
<pre><code>import psycopg2
from psycopg2.extras import RealDictCursor
ps_conn = psycopg2.connect(...)
ps_cursor = psql_conn.cursor(cursor_factory=RealDictCursor)
ps_cursor.execute('select 1 as col_a, 2 as col_b')
my_record = ps_cursor.fetchone()
print (my_record['col_a'],my_record['col_b'])
>> 1, 2
</code></pre>