When working with PostgreSQL in Stambia DI, there are a few specificities to understand and to take into account. 

Here is some useful information on these special considerations.


One metadata for each database


PostgreSQL does not support switching database from a single connection (e.g. "use mydb"). Each database connection is done to a single PG database. 

Hence, when needing to reverse schemas and tables in a Metadata, the metadata connection string (JDBC url) must specify the database to work with. 

And when you need to work with another PG database, create a new Metadata.