Status

Current state: "Under Discussion"

Discussion thread:

...

...

Please keep the discussion on the mailing list rather than commenting on the wiki (wiki discussions get unwieldy fast).

...

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"

...

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"  

...