...
The base url from constructor should be without databases, like "jdbc:postgresql://localhost:5432/" or "jdbc:postgresql://localhost:5432". The reason being that it's normal for users to switch databases within a catalog and Postgres doesn't allow changing databases within a session, and thus we need to establish multiple sessions based on the base url for different dbs in a pg instance.
The full url when connecting to the db will be with database name, like "jdbc:postgresql://localhost:5432/db"
...
Code Block |
---|
catalogs: - name: ... type: jdbc username: xxx password: yyy base-url: jdbc:<db_type>://<ip>:<port> default-database: ... # optional, dbms specific, will be access id in postgres by default |
Versions
We reply rely on the driver itself for backward compatibility. Users can also build jars with their own versions.
...
1) jdbc connection to Postgres have to be for a specific database without schema name. If there's no db specified in the url, the default db is the username.
2) when query querying a table in Postgres, users can use either <schema.table> or just <table>. The schema is optional and defaults to "postgres"
...