What is the right way of getting rows from PostgreSQL database using Psycopg2?

Question

I'm trying to get the PostgreSQL database connection in the python flask app and I would like to get it return the rows so I can have a name-based access to columns. I've tried to do it in accordance with Psycopg2 documentation, but wasn't successful.

Here's the code:

def get_connection():        
    conn = psycopg2.connect(dbname=DB_USER, user=DB_USER, password=DB_PASS, host=DB_HOST)
    cur = conn.cursor(cursor_factory=psycopg2.extras.DictRow)
    return cur

According to the documentation it seems fine but I'm getting an error:

File "/app/app.py", line 34, in get_connection
cur = conn.cursor(cursor_factory=psycopg2.extras.DictRow)
TypeError: __init__() takes 2 positional arguments but 3 were given

Can somebody please help me out with this?

Thank you.

jjanes · Accepted Answer · 2021-03-22 19:02:55Z

1

The docs you link to don't show DictRow being used in this way at all. Maybe you meant to use DictCursor, which the docs do show being used in this way.

answered Mar 22, 2021 at 19:02

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

samwell Over a year ago

I don't want to argue, but "class psycopg2.extras.DictRow(cursor) - A row object that allow by-column-name access to data." sounded to me like the thing, that I wanted. However your suggestion was right and helped me, thank you.

Collectives™ on Stack Overflow

What is the right way of getting rows from PostgreSQL database using Psycopg2?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related