Python to Create Schema in Postgres Not showing up

Question

I have this super simple Python code to connect to Postgres and to create a schema. It shows no error but I don't see the schema being added in Postgres. I must be missing something that's apparent.

I am not even sure if this's connected to Postgres because when I gave it a wrong password, it still returned without errors. But when it keeps saying connection is in place when I do trial and error. Please help~ thanks!

import psycopg2

psycopg2.autocommit = True

def build_archive(db1):

    db1 = psycopg2.connect(database='postgres', user='operator', password='1234', host='localhost', port='2280')
    cursor = db1.cursor()
    sql = """CREATE SCHEMA app_tools AUTHORIZATION operator;"""
    cursor.execute(sql)

Can the operator user create schemas in the postgres database? — Clodoaldo Neto
– Clodoaldo Neto, Commented Jul 28, 2017 at 20:45

ecarlin · Accepted Answer · 2017-07-28 20:51:05Z

1

No where in your code do you actually call build_archive() so the code inside of it is never executed. You need to add a call to build_archive() below the function definition and then you will start seeing output.

For example:

import psycopg2

psycopg2.autocommit = True

def build_archive(db1):
    db1 = psycopg2.connect(database='postgres', user='operator',         
           password='1234', host='localhost', port='2280')
    cursor = db1.cursor()
    sql = """CREATE SCHEMA app_tools AUTHORIZATION operator;"""
    cursor.execute(sql)

build_archive()  # Add this call to build_archive()

To learn more about how to use functions in Python read here.

answered Jul 28, 2017 at 20:51

ecarlin

1,2339 silver badges8 bronze badges

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

3 Comments

questiongirl Over a year ago

Hi ecarlin! Thank you for helping. I had it in there but it's still not working :/ But when I do a select statement, it's printing everything ok. Not sure why

cco Over a year ago

You need to commit after executing the DDL (create schema) statement.

questiongirl Over a year ago

Thanks again! I took away (db1) and now its working now. and yes cco, i added that commit. I thought the autocommit would do.

Collectives™ on Stack Overflow

Python to Create Schema in Postgres Not showing up

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related