Adjust the connect() call below for your database : PostgreSQL : Database PYTHON TUTORIALS

Navioo.com

PYTHON TUTORIALS » Database » PostgreSQL »

Adjust the connect() call below for your database


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

cur = dbh.cursor()
cur.execute("SELECT * FROM myTable")
cur.arraysize = 2

while 1:
    rows = cur.fetchmany()
    print "Obtained %d results from fetchmany()." % len(rows)
    if not len(rows):
        break

    for row in rows:
        print row
    
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
Fetch row one by one
Fetch row by using cursor
Parameter style
Get cursor
Using types to insert data
Commit example

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

V�rification Refresh

Enter code

Verification is used to prevent unwanted posts (spam). .

PYTHON TUTORIALS

Navioo

Database
» PostgreSQL

Buildin Function

Buildin Function

Buildin Module

CGI Web

Class

Collections

Data Type

Database

Dictionary

File

Function

Introduction

List

Network

Operator

Regular Expressions

Regular Expressions

Statement

String

Thread

Tkinker

Tuple

Windows

WxPython

XML

hits counter