Get cursor : PostgreSQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » PostgreSQL »

Get cursor


import psycopg
dbh = psycopg.connect('dbname=dbname user=username')
print "Connection successful."

cur = dbh.cursor()
cur.execute("SELECT * FROM myTable")
cur.fetchone()
    
print "Obtained %d rows" % cur.rowcount

dbh.close()

Related Scripts with Example Source Code in same category :

Query data
Basic connection to PostgreSQL with psycopg
Query PostgreSQL database with select statement
Create a table and insert data
executemany() for batch update
optimized execute() for multiple rows example
Fetch all rows after query
Adjust the connect() call below for your database
Fetch row one by one
Fetch row by using cursor
Parameter style
Using types to insert data
Commit example

PYTHON TUTORIALS

Database
» PostgreSQL

Buildin Function

Buildin Module

CGI Web

Class

Collections

Data Type

Database

Dictionary

File

Function

Introduction

List

Network

Operator

Regular Expressions

Statement

String

Thread

Tkinker

Tuple

Windows

WxPython

XML

Get cursor : PostgreSQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » PostgreSQL »

Get cursor

Leave a Comment / Note

PYTHON TUTORIALS