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

Posted by Jeremiah Peschka on Stack Overflow See other posts from Stack Overflow or by Jeremiah Peschka
Published on 2010-04-02T22:21:22Z Indexed on 2010/04/02 22:23 UTC
Read the original article Hit count: 396

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about plpgsql