Fetch row one by one : PostgreSQL « Database « Python Tutorial

Python Tutorial 1.  Introduction 2.  Data Type 3.  Statement 4.  Operator 5.  String 6.  Tuple 7.  List 8.  Dictionary 9.  Collections 10.  Function 11.  Class 12.  File 13.  Buildin Function 14.  Buildin Module 15.  Database 16.  Regular Expressions 17.  Thread 18.  Tkinker 19.  wxPython 20.  XML 21.  Network 22.  CGI Web 23.  Windows Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorial C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Python Tutorial » Database » PostgreSQL   15. 4. 9. Fetch row one by one 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:     row = cur.fetchone()     if row is None:         break     print row      dbh.close() 15. 4. PostgreSQL 15. 4. 1.  Query data 15. 4. 2.  Basic connection to PostgreSQL with psycopg 15. 4. 3.  Query PostgreSQL database with select statement 15. 4. 4.  Create a table and insert data 15. 4. 5.  executemany() for batch update 15. 4. 6.  optimized execute() for multiple rows example 15. 4. 7.  Fetch all rows after query 15. 4. 8.  Adjust the connect() call below for your database 15. 4. 9.  Fetch row one by one 15. 4. 10.  Fetch row by using cursor 15. 4. 11.  Parameter style 15. 4. 12.  Get cursor 15. 4. 13.  Using types to insert data 15. 4. 14.  Commit example

www.java2java.com | Contact Us

Copyright 2010 - 2030 Java Source and Support. All rights reserved.

All other trademarks are property of their respective owners.