sql -使用通配符对带有psycopg2组合的select语句？

SELECT * FROM table_name WHERE column_name LIKE 'A%';

SELECT * FROM table_name WHERE column_name LIKE 'A_';

import psycopg2

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

# 创建游标
cur = conn.cursor()

# 执行select语句
cur.execute("SELECT * FROM table_name WHERE column_name LIKE 'A%'")

# 获取查询结果
rows = cur.fetchall()

# 遍历结果
for row in rows:
    print(row)

# 关闭游标和连接
cur.close()
conn.close()