How can I execute pl/pgsql code without creating a function?

Question

With SQL Server, I can execute code ad hoc T-SQL code with full procedural logic through SQL Server Management Studio, or any other client. I've begun working with PostgreSQL and have run into a bit of a difference in that PGSQL requires any logic to be embedded in a function.

Is there a way to execute PL/PGSQL code without creating an executing a function?

Answer 1

No, not yet. Version 9.0 (still alpha) will have this option (do), you a have to wait until it's released.

Answer 2

Postgres 9

DO $$ select * from foo; $$