语法错误:SELECT username FROM TAMS WHERE NAME IN caner

Question

我在下面得到一个语法错误。然而，我想不通。如何运行此查询。

myCode:

conn = psycopg2.connect( user = "postgres", password = "*****", host = 
"127.0.0.1", port = "5432")
cur = conn.cursor()
cur.execute("SELECT username FROM TAMS WHERE NAME IN {}".format('caner'))

错误：

rows= cur.execute("SELECT username FROM TAMS WHERE NAME IN {}".format('caner'))
psycopg2.errors.SyntaxError: HATA:  "caner"  yerinde söz dizim hatası
LINE 1: SELECT username FROM TAMS WHERE NAME IN caner

Answer 1

in之后的元素应该用括号括起来：

"SELECT username FROM TAMS WHERE NAME IN ({})".format('caner')