How to query data using fetchall()
Python
# GET THE CONNECTION OBJECTconn = get_connection()# CREATE A CURSOR USING THE CONNECTION OBJECTcurr = conn.cursor()# EXECUTE THE SQL QUERYcurr.execute("SELECT * FROM students;")# FETCH ALL THE ROWS FROM THE CURSORdata = curr.fetchall()# PRINT THE RECORDSfor row in data: print(row)# CLOSE THE CONNECTIONconn.close() |
Output:
Output for fetchall()
In the above code, we create a connection and query using SELECT * FROM students which fetches the entire dump of the students table. In order to query data in the python code, we can make use of fetchall(). The fetchall() method fetches all the records that we got from our SQL query (the SELECT query in this case) and provides them in a list. The list consists of tuples where each tuple consists of all the column values present in the particular record or row.
PostgreSQL Python – Querying Data
Psycopg2 acts as a bridge between Python applications and PostgreSQL databases. Widely employed in diverse Python systems, from web applications to data analysis tools and other software projects, Psycopg2 enables developers to execute queries and manipulate data stored in PostgreSQL databases.
In this article, we will see What Psycopg 2?, and how to use PostgreSQL using pyscopg2 in Python for executing query data.
Contact Us