Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostgreSQL meta commands not working. Getting `pgspecial not installed' even though it is installed #128

Open
mayankkaizen opened this issue Sep 30, 2018 · 1 comment

Comments

@mayankkaizen
Copy link

I have set up an environment in Anaconda and everything (SQLAlchemy, ipython-sql, pgspecial etc) is installed in this environment except for PostgreSQL. I am able to do everything SQL related in Jupyter Notebook except for running meta-commands like \d.

When I run this -

%sql \d

This raises ImportError: pgspecial not installed. However, running import pgspecial or from pgspecial.main import PGSpecial commands immediately after this raises no issue.

I have even tried installing pgspecial at global level, but I am still getting same error.

How to resolve this issue?

@lawalogunfowora
Copy link

Restart the kernel, worked for me.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants