Menu
I'm trying to write scripts that use PostGIS functions using the PyCharm Database Navigator.
PostGIS and PostgreSQL were installed using Homebrew on Mac.
The debugger does not recognize any functions that are loaded as part of the PostGIS extensions for PostgreSQL and raises errors when trying to run a script. Creating a simple table with a geometry data type fails, whereas the same command executes in PSQL.
Do I need to do any special configuration of the database connection?
852
asked Oct 21 '25 13:10
Came across precisely the same issue today (postgis queries work in psql but fail in the PyCharm DB console). Looks like it's a bug in PyCharm 5 - upgrading to PyCharm 2016 fixed the issue. There is a related bug in JetBrains' issue tracker failed against IntelliJ Idea of the same generation as PyCharm 5.
150
answered Oct 23 '25 04:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With