connector = psycopg2.connect(host="127.0.0.1",database="pdb",user="pgusr",port=5432, password="pgpsw")
cursor    = connector.cursor()

sql = "insert into test_table values('1','python')"
cursor.execute(sql)
sql = "insert into test_table values('2','パイソン')"
cursor.execute(sql)
sql = "insert into test_table values('3','ぱいそん')"
cursor.execute(sql)

connector.commit()

cursor.close()
connector.close()