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 use the schemaName attribute in the metadata.properties file to specify the default schema. See Using the metadata.properties file.

PostgreSQL SCM Packaging Patterns

...

Use the specified folder for listed PostgreSQL database operations.

Operation and Object Type	Packaging Folder	Archived
CREATE/ALTER/DROP DATABASE LINK	`sql_direct`	Yes
CREATE/ALTER/DROP FUNCTION	`sql_direct`	Yes
CREATE/ALTER/DROP INDEX	`ddl`, `ddl_direct`, `sql_direct`,	Yes
CREATE/ALTER/DROP PROCEDURE	`procedure`	No
CREATE/ALTER/DROP QUEUE	`sql_direct`	Yes
CREATE/ALTER/DROP SEQUENCE	`ddl`, `ddl_direct`, `sql_direct`	Yes
CREATE/ALTER/DROP SYNONYM	`ddl`, `ddl_direct`, `sql_direct`	Yes
CREATE/ALTER/DROP TABLE	`ddl`, `ddl_direct`, `sql_direct`	Yes
CREATE/ALTER/DROP TRIGGER	`trigger`	No
CREATE/ALTER/DROP TYPE	`sql_direct`	Yes
CREATE/ALTER/DROP VIEW	`view`	No
CREATE/ALTER/DROP VIEW INDEX	`ddl`, `ddl_direct`, `sql_direct`	Yes
RENAME <DB_OBJECT>	`sql_direct`	Yes

Operation	Packaging Folder	Archived
INSERT, UPDATE, DELETE, SELECT	data_dml	Yes
GRANT, REVOKE	sql_direct	Yes

Do not put error-handling statements in the SQL scripts.

...