CREATE FUNCTION function_name()
  RETURNS TRIGGER AS
$trigger$
BEGIN
  <FUNCTION BODY>
END;
$trigger$ LANGUAGE plpgsql;

...org.postgresql.util.PSQLException: Unterminated dollar quote started at position...

Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.jdbc.datasource.init.DataSourceInitializer#0': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #63 of class path resource [db/initDB.sql]: CREATE FUNCTION function_name() RETURNS TRIGGER AS $trigger$ BEGIN <FUNCTION BODY>; nested exception is org.postgresql.util.PSQLException: Unterminated dollar quote started at position 50 in SQL CREATE FUNCTION function_name() RETURNS TRIGGER AS $new_emp$ BEGIN <FUNCTION BODY>. Expected terminating $$