Empty SQL response of psycop2 query, but when querying via console it returns a string?

Question

Python

def show_all_orders():
    conn = try_connect()
    cursor = conn.cursor()
    try:
        rows = cursor.execute("SELECT * FROM orders")
        conn.commit()
        conn.close()
        cursor.close()
        print('Записи таблицы orders получены')
        return rows
    except Exception as e:
        print(f'Ошибка выборки записей orders: {str(e)}')
    print('Окончание запроса к таблице orders')

print(rows) returns None

Answer 1

fetchall

cur.execute("SELECT * FROM orders;")
rows = cur.fetchall()