Thread: How to turn on pgScript in pgAdmin
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. Thanks in advance! -- View this message in context: http://postgresql.nabble.com/How-to-turn-on-pgScript-in-pgAdmin-tp5837274.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Hi,
2015-02-09 22:25 GMT+01:00 slavrenz <slavrenz@outlook.com>:
2015-02-09 22:25 GMT+01:00 slavrenz <slavrenz@outlook.com>:
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.
--
Thanks for the quick reply! You're right, I probably should have posted the exact error message, but in this case, it was the button issue. I will try to remember better posting etiquette for the future...but thanks again! -- View this message in context: http://postgresql.nabble.com/How-to-turn-on-pgScript-in-pgAdmin-tp5837274p5837313.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.