I'd really like to use an IF, ELSE construct and execute multiple statements within the IF and ELSE blocks, but I don't wish to save my commands to the database as a stored procedure or function. Can I do this in PostgreSQL?

1 Answer 1


There is the DO command for ad-hoc plpgsql execution.
But you cannot pass parameters or return rows directly to / from a DO command.

BTW, strictly speaking, Postgres does not have "stored procedures" before Postgres 11. Just functions providing very similar functionality. See:

  • Your response was very informative. Thanks for the extra caveat.
    – Jellicle
    Jun 25, 2015 at 17:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.