You need to explicitly tell your JetBrains tool to introspect the database using JDBC metadata.

I think the reason it (sometimes) works in Datagrip but not PyCharm, IntelliJ, etc is because the default settings can be different across tools and even versions of those tools.

For PyCharm, this is how you enable introspection via JDBC metadata.

I'm happy to post my exact configs and connection string if it's helpful, but I think this is what's missing from the answers above.