Learning PostgreSQL 11 - Third Edition

Executing SQL commands

Suppose that the connection is established and there is a conn variable that refers to the instance of the connection class. To execute an SQL command, it's necessary to create a cursor object that will represent the context of the command. Cursors are created by calling the connection.cursor() method of a connection, as follows:

cur = conn.cursor()

Now the cur variable refers to the cursor object. Optionally, the cursor() method can take the following parameters:

• name: When specified, the cursor will represent a server-side cursor. When not, it is a client-side cursor. The difference between client-side and server-side cursors is that the first would usually download the whole result set and store it in memory, and ...