import sqlite3
import psycopg2

conn = sqlite3.connect("/home/http/famille/famille.db",
                       detect_types=sqlite3.PARSE_DECLTYPES)
conn.row_factory = sqlite3.Row
conn.execute("PRAGMA foreign_keys=ON")
cur = conn.execute("SELECT id, user_name, password from users")

authdb = psycopg2.connect("postgres://auth_master@localhost/authdb")
sql_str = "INSERT INTO users(id, name, password) VALUES(%s, %s, %s)"
with authdb.cursor() as c:
    for id, name, password in cur:
        c.execute(sql_str, (id, name, password))
authdb.commit()
authdb.close()