嘿，當我嘗試使用連接到資料庫時psycopg.connect()，出現以下錯誤：
Traceback (most recent call last):
File "C:\Users\Aditya\AppData\Local\Programs\Python\Python310\lib\site-packages\psycopg\conninfo.py", line 97, in _parse_conninfo
return pq.Conninfo.parse(conninfo.encode())
File "psycopg_binary\\pq/conninfo.pyx", line 30, in psycopg_binary.pq.Conninfo.parse
psycopg.OperationalError: invalid connection option "database"
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\Users\Aditya\Desktop\Aditya\TGbot\dbhelper.py", line 3, in <module>
conn = psycopg.connect(
File "C:\Users\Aditya\AppData\Local\Programs\Python\Python310\lib\site-packages\psycopg\connection.py", line 561, in connect
conninfo = make_conninfo(**params)
File "C:\Users\Aditya\AppData\Local\Programs\Python\Python310\lib\site-packages\psycopg\conninfo.py", line 56, in make_conninfo
_parse_conninfo(conninfo)
File "C:\Users\Aditya\AppData\Local\Programs\Python\Python310\lib\site-packages\psycopg\conninfo.py", line 99, in _parse_conninfo
raise e.ProgrammingError(str(ex))
psycopg.ProgrammingError: invalid connection option "database"
但是當我沒有傳遞資料庫引數時，我沒有收到任何錯誤......這是我的代碼：
import psycopg
conn = psycopg.connect(
host="localhost",
database="suppliers",
user="postgres",
password="pas")
我在這里做錯了什么？我確定我已經用那個名字創建了資料庫，密碼也是正確的
uj5u.com熱心網友回復：
你看起來正在使用psycopg3. database是不推薦使用的引數，psycopg2并且不允許在psycopg3. 您將需要使用此處dbname的串列，如連接頁面中的psycopg3頁面所示。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/321684.html
標籤：蟒蛇-3.x 数据库 PostgreSQL