#!/usr/bin/env python
# -*- coding: iso-8859-1 -*-

# Before run this script, don't forget create adress-book data base

import pg

query_contact = """
create
 table contact(id serial primary key, 
	name  text,
	tel   int,
	email text,
	other text);
"""
conn = pg.connect(dbname="adress-book", user="crac")
conn.query(query_contact)
conn.close()