Can I create a trigger in PostgreSQL while specifying the schema using Liquibase Enterprise?

Applies to

• Liquibase Enterprise (Datical DB)

Conditions

• Using a PostgreSQL database

Question

Can I create a trigger in PostgreSQL while specifying the schema using Liquibase Enterprise?

Answer

Postgres does not support specifying the schema with the trigger name (see more information in the PostgreSQL documentation).

To handle this, you'll need to use schema-level (schema-specific) folders for triggers with the schema name specified in the folder's metadata.properties file. Our documentation, PostgreSQL Server Database Objects and Packaging, provides more information on this, along with an example.

Related Article(s)

• PostgreSQL Server Database Objects and Packaging