Проблема с питоном и PostgreSQL
Как решить проблему?
Есть такой код, нужно как-то автоматизировать чтобы он создал сам таблицу
Task exception was never retrieved
future: <Task finished name='Task-10' coro=<Dispatcher._process_polling_updates() done, defined at C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\dispatcher.py:407> exception=UndefinedTable('ОШИБКА: отношение "users" не существует\nLINE 1: SELECT * FROM users WHERE id = (800113578)\n ^\n')>
Traceback (most recent call last):
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\dispatcher.py", line 415, in _process_polling_updates
for responses in itertools.chain.from_iterable(await self.process_updates(updates, fast)):
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\dispatcher.py", line 235, in process_updates
return await asyncio.gather(*tasks)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\handler.py", line 101, in notify
await self.dispatcher.middleware.trigger(f"pre_process_{self.middleware_key}", args + (data,))
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\middlewares.py", line 53, in trigger
await app.trigger(action, args)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\site-packages\aiogram\dispatcher\middlewares.py", line 106, in trigger
await handler(*args)
File "C:\Users\Administrator\Desktop\!!bot\middlewares.py", line 14, in on_pre_process_update
user = sql_orm.select_user(id)
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Administrator\Desktop\!!bot\sql_orm.py", line 13, in select_user
sql.execute(f'SELECT * FROM users WHERE id = (%s)', [id])
psycopg2.errors.UndefinedTable: ОШИБКА: отношение "users" не существует
LINE 1: SELECT * FROM users WHERE id = (800113578)
^