I have been using pgAdmin for a while, and I am looking for a way to declare variables within the program (on the SQL Editor side, not the Graphical Query side). pgScript appears to be the answer, but I cannot get it to work.
When I try a simple variable declaration (e.g., DECLARE @StartDate;) it returns a syntax error. I'm guessing this is because pgScript is not enabled for some reason. Is there anything that I need to do to "turn on" this feature in pgAdmin 1.18? I have tried searching online and through this forum, but all of the "how to" posts seem to assume that you already have everything up and running.
It's so much easier if you give us the exact error message you had.
Anyway, just guessing you didn't click on the right button. You shouldn't click on the usual green arrow, but on the green arrow with PGS written on it.
