python连接,操作pgsql

Python连接,操作PGSQL

1.安装python

• Mac上 brew install python
• linux上 apt-get install python

2.安装psycopg2

• 在 https://pypi.python.org/pypi/psycopg2/下载psycopg2 2.6.1
• 解压后进入文件夹psycopg2 2.6.1
• 输入命令 sudo python setup.py install

3.连接PGSQL,python代码

    import psycopg2
    conn = psycopg2.connect(database="testdb", user="postgres", password="pass123", host="127.0.0.1", port="5432")
    print "Opened database successfully"  

4.创建表

    import psycopg2

    conn = psycopg2.connect(database="testdb", user="postgres", password="pass123", host="127.0.0.1", port="5432")
    print "Opened database successfully"

    cur = conn.cursor()
    cur.execute('''CREATE TABLE COMPANY
           (ID INT PRIMARY KEY     NOT NULL,
           NAME           TEXT    NOT NULL,
           AGE            INT     NOT NULL,
           ADDRESS        CHAR(50),
           SALARY         REAL);''