Code completion not working in PyCharm

Question

I am trying to get code completion for the psycopg2 library in PyCharm 2018.1 but it is not showing cursor class methods like .execute() or .fetchone().

Here is my code:

import logging
import psycopg2 as pg

#Code completion works fine here.
logger = logging.getLogger()
logger.info("Hello World!")

#Code completion works fine here.
con = pg.connect("dbname='postgres' port='5432'")

#Code completion not working!
cur = con.cursor()

What does not working mean? What happens when you are editing code? Have you contacted Jet Brains? — Code-Apprentice
– Code-Apprentice, Commented Apr 8, 2018 at 0:02

vishes_shell · Accepted Answer · 2018-04-08 00:31:23Z

3

That's because:

Psycopg 2 is mostly implemented in C as a libpq wrapper

So you have autocomletion for pg.connect() because it exists in __init__.py and mostly the rest of features are listed as .c and .h files https://github.com/psycopg/psycopg2/tree/master/psycopg that are being handled by setup.py.

answered Apr 8, 2018 at 0:31

vishes_shell

23.8k7 gold badges74 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saravanan G · Accepted Answer · 2021-08-30 15:22:07Z

0

In my case the solution is to reset the settings. From the main menu, select File > Manage IDE Settings > Restore Default Settings.

Alternatively, press Shift twice and type Restore default settings

edited Aug 30, 2021 at 15:22

Saravanan G

5811 gold badge9 silver badges27 bronze badges

answered Aug 30, 2021 at 11:46

Wotori Movako

3362 silver badges9 bronze badges

Collectives™ on Stack Overflow

Code completion not working in PyCharm

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related