create function with dollar quoted body

I don't know if this is a netbeans problem or a jdbc problem, but when
executing a 'CREATE FUNCTION' script with the body dollar quoted, an
error results.

Reading around this seems to be to do with the script being parsed for
semicolons as line terminators even inside dollar-quoted strings? Or
perhaps not?

Any pointers much appreciated

Thanks
Jack