I have a newbie question: is complex functionality in Postgres supported?
We have very complex database that uses the following (in addition to regular DDL SQL):
CREATE OR REPLACE VIEW
CREATE OR REPLACE RULE
CREATE OR REPLACE FUNCTION
I consider now to use Liquibase, but I afraid it may not work after a big effort.
I do understand that we need to use Custom SQL (http://www.liquibase.org/manual/custom_sql ).
Question, if Liquibase will be able to understand that the Custom SQL is changed (for example a Custom SQL for the creation of a function) and will change the specific Custom SQL for the new one.
Any help will be appreciated.