PyGreSQL

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
第11行: 第11行:
 
  postgres$ python  
 
  postgres$ python  
 
  >>> import _pg
 
  >>> import _pg
 +
Syntax:
 +
connect([dbname], [host], [port], [opt], [tty], [user], [passwd])
 +
 
  >>> db = _pg.connect('dellstore2','localhost')
 
  >>> db = _pg.connect('dellstore2','localhost')
 +
or
 +
db = _pg.connect('dellstore2','localhost', 5432, None, None, 'postgres', 'postgres')
 +
or
 +
db = _pg.connect(dbname='dellstore2', host='localhost', user='postgres', passwd='postgres')
 +
 
  >>> db.query("select * from categories")
 
  >>> db.query("select * from categories")
 
  category|categoryname
 
  category|categoryname

2007年3月21日 (三) 22:47的版本

PyGreSQL – PostgreSQL module for Python

It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

http://www.pygresql.org/

Install

#apt-get install python2.3-pygresql

#su postgresql
postgres$ python 
>>> import _pg

Syntax:

connect([dbname], [host], [port], [opt], [tty], [user], [passwd])

>>> db = _pg.connect('dellstore2','localhost')
or 
db = _pg.connect('dellstore2','localhost', 5432, None, None, 'postgres', 'postgres')
or
db = _pg.connect(dbname='dellstore2', host='localhost', user='postgres', passwd='postgres')
>>> db.query("select * from categories")
category|categoryname
--------+------------
       1|Action
       2|Animation
       3|Children
       4|Classics
       5|Comedy
       6|Documentary
       7|Drama
       8|Family
       9|Foreign
      10|Games
      11|Horror
      12|Music
      13|New
      14|Sci-Fi
      15|Sports
      16|Travel
(16 rows)
(1 row)
分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱