Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python
- # -*- coding: utf-8 -*-
- from psycopg2 import connect
- import sys
- from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT
- con = None
- con = connect(user='postgres', password='poilk', port=5432)
- dbname = "name_db"
- con.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
- cur = con.cursor()
- cur.execute('CREATE DATABASE ' + dbname)
- cur.close()
- con.close()
- Traceback (most recent call last):
- File "C:Program Files (x86)JetBrainsPyCharm 2016.1.2helperspydevpydevd.py", line 1531, in <module>
- globals = debugger.run(setup['file'], None, None, is_module)
- File "C:Program Files (x86)JetBrainsPyCharm 2016.1.2helperspydevpydevd.py", line 938, in run
- pydev_imports.execfile(file, globals, locals) # execute the script
- File "D:/ALEX/Proktor/From_life_to_life/Work_with_db.py", line 15, in <module>
- cur.execute('CREATE DATABASE ' + dbname)
- psycopg2.ProgrammingError: ОШИБКА: база данных "name_db" уже существует
- табл.1 - user_name (ID, name, password)
- табл.2 - additionally (age, sex, hp, items, knowledge)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement