calling a script with parameter

[techtoys4321]

Is there a way to run an sql script that takes a parameter?

Thanks

[BenoitDuffez]

What do you mean a parameter? Can you provide an example of what you expected to do?

[sasax]

The Problem is, when you have a Function it has Semicolons in it. CREATE FUNCTION testmaximum() RETURNS TRIGGER AS $$ //some statement with semicolon $$ LANGUAGE plpgsql; The Programm must memorize the String '$$' and ignore everything until it gets the same String '$$'

[BenoitDuffez]

Just add this:

delimiter $$

at the top of your script.

[sasax]

I changed the code and this is the result and it works. I uploaded it here sasax/patch-1

[BenoitDuffez]

If you feel you can improve the code, submit a pull request. Otherwise if your problem is fixed you may close this issue.