On Fri, May 1, 2009 at 6:25 AM, Carlo Stonebanks <stonec.register@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
