Page Comparison

...

• Do not qualify objects with the database name as PostgreSQL connections represent one database at a time.

• For a Single-Schema project, you don’t need to qualify object names with the schema name. If they are not qualified, Datical DB uses the default schema if it is specified.

• For a Multi-Schema project, you must qualify object names with the schema name so they get deployed to the correct schema during packaging.You can

  • Some objects, eg. triggers, do not allow schema qualification when creating the object. In this case you must use the schemaName attribute in the metadata.properties file for a schema-level folder to specify the

  default

  • schema. See Using the metadata.properties file.

PostgreSQL SCM Packaging Patterns

...