Eu tenho a seguinte função para criar um banco de dados PostgreSQL com psycopg:
def create_database() -> None:
"""A function for creating a PostgreSQL database."""
db_name = ('test_db',)
sql_1 = """SELECT datname FROM pg_database"""
sql_2 = """CREATE DATABASE %s"""
with connect('create') as conn:
try:
cur = conn.cursor()
cur.execute(sql_1)
databases = cur.fetchall()
if db_name in databases:
print(f'Database named {db_name[0]} already exists.')
else:
cur.execute(sql_2, db_name)
cur.close()
print('Creating database...')
conn.commit()
print('Database created.')
except (Exception, DatabaseError) as error:
print(error, '\n-> Could not create database.')
Dá o seguinte erro:
syntax error at or near "$1"
LINE 1: CREATE DATABASE $1
^
-> Could not create database.
Qual é o problema?
Modificando linhas relevantes para
resolve o problema.