CODEWITHSUNDEEP
postgresqlmavenliquibase
3Qn
3Qn

Reputation: 140

Liquibase drop all functions - postgresql

I need some tips on how to how define a custom "worker" or "profile" for Liquibase. I would like to use the drop-all task from Maven(3.3.5), but it does not remove functions from the database. (PostgreSQL)

Upvotes: 0

Views: 979

Answers (1)

SteveDonie
SteveDonie

Reputation: 9016

You would need to write an extension to Liquibase that would be able to query Postgres for the list of functions, as well as code to generate the correct SQL for Postgres to drop functions. This will not be a trivial exercise.

The basics of writing a Liquibase extension are described on the Liquibase website, but it would require a fair amount of learning to understand the Liquibase internals.

Upvotes: 1

Related Questions