Python-сообщество

 import psycopg2
i = 1
n = "Имя"
s = "Фамилия"
y = "0000-00-00"
t = "00:00:00"
con = psycopg2.connect(
    host = "127.0.0.1",
    database = "test",
    user = "postgres",
    password = "pass")
cur = con.cursor()
cur.execute("select id from testing_table")
rows = cur.fetchall()
for r in rows:
    print (f"id {r[0]}")
cur.close()
con.close()
i = int(input ("Введите ID:  "))
print (i)
n = str(input ("Введите Имя:  "))
print (n)
s = str(input ("Введите Фамилию:  "))
print (s)
y = str(input ("Введите гггг-мм-дд рождения:  "))
print (y)
t = str(input ("Введите 00:00:00 время:  "))
print (i, n, s, y, t)
con = psycopg2.connect(
    host = "127.0.0.1",
    database = "test",
    user = "postgres",
    password = "Best4KamCH")
    
cur = con.cursor()
cur.execute("insert into testing_table (id,name,second,year,time) values (%s, %s, %s, %s, %s)", (
    i, name, second, year, time))
cur.execute("select * from testing_table")
rows = cur.fetchall()
for r in rows:
    print (f"id {r[0]} name {r[1]} second {r[2]} year {r[3]} time {r[4]}")
con.commit()
cur.close()
con.close()

 new_id = max([i[0] for i in rows])+1