kZAggrVT

1conn = psycopg2.connect(database=db_info.get('NAME'), user=db_info.get('USER'), password=db_info.get('PASSWORD'), host=db_info.get('HOST'), port=db_info.get('PORT'))
2    c = conn.cursor()
3    kom = "CREATE TABLE IF NOT EXISTS ch_{} (id INTEGER PRIMARY KEY, nickname   VARCHAR)".format(chat_id)
4    c.execute(kom)
5    c.close()
6    conn.close()
7
8@bot.message_handler(commands=['register'])
9def reg_user(message):
10    chat_id = str(message.chat.id)[1:]
11    conn = psycopg2.connect(database=db_info.get('NAME'), user=db_info.get('USER'), password=db_info.get('PASSWORD'), host=db_info.get('HOST'), port=db_info.get('PORT'))
12    c = conn.cursor()
13    try:
14        kom = "SELECT nickname FROM ch_{}".format(chat_id)
15        curs = c.execute(kom)
16        data = curs.fetchall()
17	
18File "D:/Programming/python/mason4pdabot/UselessBot.py", line 32, in reg_user
19    curs = c.execute(kom)
20psycopg2.ProgrammingError: relation "ch_33578100" does not exist
21LINE 1: SELECT nickname FROM ch_33578100