How should I be escaping the database name when using

Question

How should I be escaping the database name when using

psycopg2 here? I've tried a backtick, and multiple double quotes.

cur.execute(f"CREATE DATABASE `{dbname}` TEMPLATE template0 ENCODING 'UTF8'")

psycopg2.errors.SyntaxError: syntax error at or near "`"
LINE 1: CREATE DATABASE `crmpicco-sf440_31m` TEMPLATE template0 EN...

0

13.06.2022

4 ответов

28 просмотров

Craig R Morton Автор вопроса

Fayaz Khan
IIRC, database names don't require quotes. Have yo...

yes, the - is an issue. cur.execute(f"CREATE DATABASE {dbname} TEMPLATE template0 ENCODING 'UTF8'") psycopg2.errors.SyntaxError: syntax error at or near "-" LINE 1: CREATE DATABASE crmpicco-sf440_31m TEMPLATE template0 ENCO...

0

13.06.2022

drunktimelord

uh don't use f strings in database queries

0

13.06.2022

Craig R Morton Автор вопроса

drunktimelord
uh don't use f strings in database queries

yes, I absolutely agree. This has no public-facing, customer input though - it's an admin script only

0

13.06.2022