Django/Postgres: Parameterized Queriy does not work

Question

i have just started diving into raw queries in django.

i am trying to change a schema name in my postgres, but my SQL query does not work

here's the code that i run in django shell:

>>> from django.db import connection
>>> cursor = connection.cursor()
>>> query = "ALTER SCHEMA %s RENAME TO %s;"
>>> data = ('thor', 'thor1')
>>> cursor.execute(query, data)

Error:

django.db.utils.ProgrammingError: syntax error at or near "'thor'"
LINE 1: ALTER SCHEMA 'thor' RENAME TO 'thor1';

i believe that those quotes are the root of my problem.

any idea how can i make this work ?

frozenOne · Accepted Answer · 2020-03-19 17:57:03Z

1

Can't use query parameters here as they'll add single quotes which are not supported by postgres.

Try:

>>> from django.db import connection
>>> cursor = connection.cursor()
>>> data = ('thor', 'thor1')
>>> query = """ALTER SCHEMA %s RENAME TO %s;""" % data
>>> cursor.execute(query)

answered Mar 19, 2020 at 17:57

frozenOne

5642 silver badges9 bronze badges

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

7 Comments

Django DO Over a year ago

So i can use Parameterized queries anywhere else ?

frozenOne Over a year ago

This might help: docs.djangoproject.com/en/3.0/topics/db/sql

Django DO Over a year ago

Thank you, i'll look into it later.

frozenOne Over a year ago

Can I know the usecase? You could get data from the requests and use this setup to achieve the result you want.

Django DO Over a year ago

just experimenting, nothing serious :D

|

Collectives™ on Stack Overflow

Django/Postgres: Parameterized Queriy does not work

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related