A database is not being created in python PostgreSQL

Question

import psycopg2
from config import host, user, password, db_name, port

connection = None
try:
    # подключаемся к базе
    connection = psycopg2.connect(
        host=host,
        user=user,
        password=password,
        database=db_name,
        port=port

    )
    connection.autocommit = True

    # cursor нужен чтобы взаимодействовать с БД
    # сейчас создаем нашу БД
    with connection.cursor() as cursor:
        cursor.execute(
            """CREATE TABLE IF NOT EXISTS data1 (
                price int NOT NULL,
                styles text NOT NULL,
                runes text);"""
        )


except Exception as _ex:
    print("[INFO] Error while working with PostgreSQL", _ex)
finally:
    if connection:
        connection.close()
        print("[INFO] PostgreSQL connection closed")

config

host = "127.0.0.1"
user = "postgres"
password = "14101999"
db_name = "data"
port = "5432"

When executing , it outputs [INFO] Error while working with PostgreSQL

I do not understand at all what the problem is and why the database is not being created, I seem to have indicated everything correctly in config...

Update the question to include the _ex portion of the exception message. — Adrian Klaver
– Adrian Klaver, Commented Feb 9, 2023 at 16:23

Adrian Klaver · Accepted Answer · 2023-02-09 16:22:02Z

1

I don't see where you are creating a database. psycopg2.connect() has to connect to an existing database. So either you create the database outside the Python script or you connect to an existing database, best practices the database named postgres, and then issue a CREATE DATABASE <some_name>. You would then need to close the existing connection and create a new one to the new database.

answered Feb 9, 2023 at 16:22

Adrian Klaver

20.3k3 gold badges24 silver badges40 bronze badges

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

2 Comments

Bounty_Hunter Over a year ago

with connection.cursor() as cursor: cursor.execute( """CREATE TABLE IF NOT EXISTS data1 ( price int NOT NULL, styles text NOT NULL, runes text);""" ) here I am creating a database, or is that not it?

Adrian Klaver Over a year ago

No, the statement is pretty clear you are creating a table. You need to update your question with the complete error message. This is CREATE DATABASE.

Collectives™ on Stack Overflow

A database is not being created in python PostgreSQL

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