import psycopg2
conn = psycopg2.connect("dbname=mydatabase user=myuser password=mypassword")
cur = conn.cursor()
files_name = ["file_789", "file_456", "file_555", "file_111"]
sql = "SELECT filename FROM xml_job WHERE filename IN %s"
cur.execute(sql, (tuple(files_name),))
matching_files = cur.fetchall()
matching_files = [f[0] for f in matching_files]
print(matching_files)
cur.close()
conn.close()
这是我目前的代码.它给出了以下输出:
[("file_555",), ("file_111",)] # output
我的PostgreSQL表有两行:一行名为‘文件名’,另一行名为‘备注’ 我希望我的输出如下:
[("file_555","remark1"), ("file_111","remark2")] # output
个