AttributeError: 'module' object has no attribute 'connect' in the pgdb module using python

Question

    import pgdb
    myConnection = pgdb.connect( host=hostname, user=username, password=password, database=database )
    doQuery( myConnection )
    myConnection.close()

I get the following error when i run the script.

>>> AttributeError: 'module' object has no attribute 'connect'. Please help me out

After the import statement, do `dir(pgdb)` and post the output. — Romit, Jul 13 '20 at 12:41

score 1 · Accepted Answer · answered Jul 13 '20 at 14:06

1

The classname is Connection in the repo https://github.com/KehaoWu/pgdb/blob/master/pgdb/pgdb.py#L15

PYPY project pypi.org/project/pgdb

answered Jul 13 '20 at 14:06

Vikas Mulaje

727
6
11

score 0 · Answer 2 · answered Aug 19 '22 at 17:48

It is like that you have installed the "wrong" pgdb module. Try this:

python3.9 -m pip uninstall pgdb
python3.9 -m pip   install PyGreSQL

"You may either choose to use the “classic” PyGreSQL interface provided by the pg module or else the newer DB-API 2.0 compliant interface provided by the pgdb module." per http://www.pygresql.org/contents/pgdb/introduction.html . It is confusing to have two different modules with the same name.

AttributeError: 'module' object has no attribute 'connect' in the pgdb module using python

2 Answers2