Re: How to turn on pgScript in pgAdmin

Hi,

2015-02-09 22:25 GMT+01:00 slavrenz <slavrenz(at)outlook(dot)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.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com