Redshiftで大文字のテーブル名を検索する windows7psycopg2python3.4.4redshift `relation "table" does not exist` import 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]

>
> AWS Documentation