2014-03-16 python postgresql sql
Проверено на ubuntu 13.04 x64, Python 2.7
Создаем apt файл /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
$ wget -O psql.key https://www.postgresql.org/media/keys/ACCC4CF8.asc
$ sudo apt-key add psql.key
$ sudo apt-get update
$ sudo apt-get install postgresql-9.3 python-psycopg2
sudo -u postgres psql
postgres=# CREATE DATABASE test_base;
CREATE DATABASE
postgres=# CREATE USER test_user WITH password 'test_password';
CREATE ROLE
postgres=# GRANT ALL privileges ON DATABASE test_base TO test_user;
GRANT
import psycopg2
connect = psycopg2.connect(database='test_base', user='test_user', host='localhost', password='test_password')
cursor = connect.cursor()
cursor.execute("CREATE TABLE tbl(id INT, data JSON);")
cursor.execute('INSERT INTO tbl VALUES (1, \'{ "name":"Tester" }\');')
connect.commit()
cursor.execute("SELECT * FROM tbl;")
for row in cursor:
print(row)
connect.close()