createPackage
Note: This is a Liquibase Pro Change Type, so you need a Liquibase Pro License Key to use it.
Creates a package.
Run createPackage
To run this Change Type, follow these steps:
Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the
update
command:liquibase update
Available attributes
Name | Description | Required for | Supports | Since |
| Name of the catalog | all | ||
| Specifies which database type(s)a changeset is to be used for. See valid database type names on | all | 3.1 | |
| Encoding used in the file specified in the | all | ||
| Name of the package | all | all | |
| The SQL creating the package | all | all | |
| File containing the procedure text. Either this attribute or a nested procedure text is required. | all | all | |
| The SQL creating the procedure. You need to define either this attribute or the | all | all | |
| Specifies whether the file path is relative to the changelog file rather than looked up in the search path. Default: | all | ||
| Boolean. If the stored procedure defined by | all | ||
| Name of the schema |
Database support
Database | Notes | |
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
Google BigQuery | Supported | No |
H2 | Supported | No |
HyperSQL | Supported | No |
INGRES | Supported | No |
Informix | Supported | No |
MariaDB | Supported | No |
MySQL | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Not Supported | No |
SQL Server | Supported | No |
SQLite | Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |
createPackage examples
databaseChangeLog:
- changeSet:
id: createPackage-example
author: liquibase-docs
changes:
- createPackage:
catalogName: cat
dbms: h2, !oracle, mysql
encoding: UTF-8
packageName: A String
packageText: A String
path: com/example/my-logic.sql
relativeToChangelogFile: true
schemaName: public