PostgreSQL creating table with Python failed

Question

For some unknown reason table in database was not created. How to solve it?

import psycopg2
conn = psycopg2.connect(user='postgres', host='localhost', password='123456')
conn.autocommit = True
cur = conn.cursor()
cur.execute('CREATE DATABASE example;')
cur.execute("""CREATE TABLE HARMKA
                         (ID INT PRIMARY KEY NOT NULL,
                         PHARMACY_LICENSE CHAR(100),
                         STREET CHAR(150),
                         CITY CHAR(30));""")
cur.execute("INSERT INTO HARMKA VALUES(%s, %s, %s, %s)", (1, '12345', 'street', 'Denwer'))
cur.close()
conn.close()

If you'd tell us what went wrong, what error you received or what exactly you mean by "failed".. I mean that would be just nifty... — Adelin
– Adelin, Commented Jan 25, 2018 at 7:38
There is no error. Database is created, but table is not in Database. — cat
– cat, Commented Jan 25, 2018 at 7:39

vishes_shell · Accepted Answer · 2018-01-25 07:41:24Z

3

You need to connect to example database and then create tables and manipulate data.

conn = psycopg2.connect(database='example', user='postgres', host='localhost', password='123456')

answered Jan 25, 2018 at 7:41

vishes_shell

23.8k7 gold badges74 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cat Over a year ago

import psycopg2 conn = psycopg2.connect(user='postgres', host='localhost', password='123456') conn.autocommit = True cur = conn.cursor() cur.execute('CREATE DATABASE example;') conn = psycopg2.connect(database = 'example', user='postgres', host='localhost', password='123456') conn.autocommit = True cur = conn.cursor()

vishes_shell Over a year ago

@FootAdministration glad it helped!

Collectives™ on Stack Overflow

PostgreSQL creating table with Python failed

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related