在文件的每一行的末尾插入PostgreSQL "select“的结果

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")

# 打开文件并逐行读取内容
with open("your_file.txt", "r") as file:
    lines = file.readlines()
    for line in lines:
        line = line.strip()  # 去除行尾的换行符或空格

        # 执行PostgreSQL查询语句
        cursor = conn.cursor()
        query = "SELECT column FROM table WHERE condition"
        cursor.execute(query)

        # 获取查询结果
        result = cursor.fetchone()[0]  # 假设查询结果只有一列

        # 将查询结果追加到当前行的末尾
        line_with_result = line + " " + str(result)  # 根据文件格式和查询结果类型进行相应的转换

        # 输出处理后的行
        print(line_with_result)

# 关闭文件和数据库连接
file.close()
conn.close()