Query data : PostgreSQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » PostgreSQL »

Query data


import pgdb
cxn = pgdb.connect(user='pgsql')
cur = cxn.cursor()
cur.execute('SELECT * FROM pg_database')
rows = cur.fetchall()
for i in rows:
  print i
cur.close()
cxn.commit()
cxn.close()

Related Scripts with Example Source Code in same category :

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
Get cursor
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

Query data : PostgreSQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » PostgreSQL »

Query data

Leave a Comment / Note

PYTHON TUTORIALS