结合使用postgresql和python时，如何返回作为参数放入搜索函数的数据值的所有行值

import psycopg2

conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")

cur = conn.cursor()

search_value = "your_search_value"
query = "SELECT * FROM your_table WHERE column_name = %s"

cur.execute(query, (search_value,))
rows = cur.fetchall()

cur.close()
conn.close()

import psycopg2

conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

search_value = "your_search_value"
query = "SELECT * FROM your_table WHERE column_name = %s"

cur.execute(query, (search_value,))
rows = cur.fetchall()

cur.close()
conn.close()

for row in rows:
    print(row)