Re: Any way to execute ad-hoc pl/pgsql?

On Fri, May 1, 2009 at 6:25 AM, Carlo Stonebanks
<stonec.register@sympatico.ca> wrote:
> One of our developers asked me, "is there any way to execute arbitrary
> plpgsql"? By that I beleive he means: is there some way to execute ad-hoc
> pl/pgsql code without creating a stored procedure or a function?
>
> I believe MS SQL Server can do this - has any one heard of some sort of
> command shell to do this for PG?
>
> (I suppose one possibility would be something that created a temporary
> stored proc to execute the code, then cleaned up after itself.)

Sounds like you need anonymous blocks, which no, PostgreSQL doesn't support.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com