使用python psychopg2获取数据库中包含特定字符串的所有变量的计数

import psycopg2

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

cur = conn.cursor()

query = "SELECT COUNT(*) FROM your_table WHERE your_column LIKE '%your_string%'"

cur.execute(query)

count = cur.fetchone()[0]

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()

query = "SELECT COUNT(*) FROM your_table WHERE your_column LIKE '%your_string%'"
cur.execute(query)

count = cur.fetchone()[0]

cur.close()
conn.close()

print("包含特定字符串的变量计数：", count)