postgreSQL.cursor.create
Syntax
postgreSQL.cursor.create (connectionRef)
Params
connectionRef is a reference to a connection as returned by postgreSQL.connection.open or postgreSQL.connection.grab.
Action
Creates a new cursor associated with the specified connection.
Returns
A reference to the new cursor.
Examples
cursorRef = postgreSQL.cursor.create (connectionRef)
« 63009630
Notes
After you have created a cursor, you can use it to execute a query or to call a procedure over the associated connection.
It's perfectly okay to create multiple cursors per connection, just keep in mind that they exist in the same context as far as transactions are concerned.
When you no longer need the cursor, you can dispose it by calling postgreSQL.cursor.dispose to free all memory occupied by query results. Otherwise, the cursor will be disposed automatically when you close or release the associated connection.