I have a Postgres on a server which is available under https://somethig.my.domain/postgres on port 5432. I'm trying to connect to it via DataGrip (which uses JDBC driver underneath), but cannot figure out the connection string.
Official docs doesn't have an example with a subpath:
- jdbc:postgresql:database
- jdbc:postgresql:/
- jdbc:postgresql://host/database
- jdbc:postgresql://host/
- jdbc:postgresql://host:port/database
- jdbc:postgresql://host:port/
And I cannot find a way for a subpath there.
Please note that at least 2 different ORMs for Node.js connect to the Postgres without any issue, so it's definitely possible. The question is how to form JDBC connection string.