我在windows7和python3.4.4上使用psycopg2。在
我想从大写字母表中获取数据,但我想不通。有人能帮我吗?在
总是这样重来
relation "table" does not exist
我想把“table”改成大写。在
这是我的密码 导入psycopg2
class KindOfCoupons:
def get_coupons(self, cur, names):
coupons = {}
for name in names:
coupons[name] = cur.execute("SELECT * FROM \"" + name + "\" ;")
return coupons
def connect_redshift(self):
conn = psycopg2.connect("dbname=dbname host=host user=user password=password port=000")
return conn.cursor()
def get_coupon_used_type(self):
cur = self.connect_redshift()
names = ["TABLE", "TABLE_B", "TABLE_C"]
coupons = self.get_coupons(cur, names)
coupons[names[0]][0]
postgresql列和表名不区分大小写,,除非用引号将它们括起来(就像您一样,
"SELECT * FROM \"" + name + "\" ;"
)。在看到这个答案:https://stackoverflow.com/a/21798517/1453822
相关问题 更多 >
编程相关推荐