python插入Null值数据到Postgresql

数据库中最好插入Null值.

在python中, 暂时没找到通过sql语句的方式插入Null值. 

推荐使用轮子的方法.

 

def insert_sample_data(self, values): # added self since you are referencing it below
    with self.con.cursor() as cur:
        sql = "insert into sampletable values (%s, %s, %s)" # Use %s for parameters
        cur.executemany(sql, values) # Pass the list of tuples directly
        self.con.commit()

list1 = [(1100, 'abc', '{"1209": "Y", "1210": "Y"}'), (1100, 'abc', None)]
self.insert_sample_data(list1) # pass the list directly

 

参考网址: 

https://stackoverflow.com/questions/52391025/how-to-insert-null-values-into-postgresql-database-using-python