Hi ,
i am trying to insert records from one table to another table in postgres
sql using the the following code
posConn.query("insert into
usr(usr_id,usr_name,usr_passwd,grp_cde,usr_type,usr_chk_till_val, \
usr_active,usr_daily_auth,usr_lst_login,usr_lst_logout,usr_shift_id,usr_role_level)
values \
('%s','%s','%s',%s,%i,%d,'%s',%i,%i,%i,%i,%i)"
%(row[0],row[1],row[2],row[3],row[4],row[5], \
row[7],row[8],row[10],row[11],row[12],row[14]) )
here row[4] column is having null value so python consides it as None but
will insert into the table it inserts as None not null value
please help how to convert None to null value
--
http://mail.python.org/mailman/listinfo/python-list
