Does Liquibase support database extension datatypes?

Applies to: 

• Liquibase Pro
• Liquibase Open Source (Community)

Conditions:

• Any version of Liquibase Pro or Open Source
• Any database

Question:

Does Liquibase support database extension datatypes? 

Answer:

In general, as long as the SQL is valid for a target database, Liquibase should not have any issues deploying the SQL.

For example, the vector datatype is not natively available in Postgres but can be added as an extension. After the extension is added and enabled in the database, a script using the vector datatype can be deployed. There isn't any additional configuration needed to be performed on the Liquibase side.

Related Article(s):

N/A