dollar sign in procedure - Postgres

General Discussion
1

Hi

I’m trying to move stored procedure between PostgresSQL instances using sql type of changeLogFile but getting following error related to dollar signs in procedure:

Liquibase Pro 3.8.7 by Datical licensed to Liquibase Pro Evaluation until Wed Apr 22 03:00:00 EEST 2020

Unexpected error running Liquibase: Unterminated dollar quote started at position 81 in SQL CREATE OR REPLACE PROCEDURE public.sp_test()

 LANGUAGE plpgsql

AS $procedure$

begin

…

I tried to use different versions of driver. For now it is postgresql-42.2.11. It did not help.
Could you please advise what can I try?

2

Would you mind sharing the whole script?  It looks similar to this issue.

So instead of using

REPLACE PROCEDURE public.sp_test()

 LANGUAGE plpgsql

AS $procedure$

begin

try

REPLACE PROCEDURE public.sp_test()

 LANGUAGE plpgsql

AS '

begin

…

end

’

Does that work out?