PHPackages                             schema-keeper/executor - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. schema-keeper/executor

ActiveLibrary[Database & ORM](/categories/database)

schema-keeper/executor
======================

Simple interaction with PostgreSQL stored procedures

v1.1.0(6y ago)218MITPHPPHP >=5.6

Since Apr 24Pushed 6y ago1 watchersCompare

[ Source](https://github.com/dmytro-demchyna/executor)[ Packagist](https://packagist.org/packages/schema-keeper/executor)[ RSS](/packages/schema-keeper-executor/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependencies (3)Versions (4)Used By (0)

Executor
========

[](#executor)

[![Minimum PHP Version](https://camo.githubusercontent.com/bb601006c55a3fd8394549eb90255f7199464ac0c6841f21393d5ebaa9b048c1/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048502d253345253344253230352e362d3838393242462e7376673f7374796c653d666c61742d737175617265)](https://php.net/)[![Minimum PostgreSQL Version](https://camo.githubusercontent.com/4f8b65fccd7db13b751c1297a3e995697ee250e57b6d92aeea5939e3eca49b08/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f506f737467726553514c2d253345253344253230392e342d3838393242462e7376673f7374796c653d666c61742d737175617265)](https://www.postgresql.org/)[![Build Status](https://camo.githubusercontent.com/1724e5fa98ddf3239ff29b36ddc753fd3fb28e0e7ab2e7f05d23b0babafb55f6/68747470733a2f2f7472617669732d63692e636f6d2f646d7974726f2d64656d6368796e612f6578656375746f722e7376673f6272616e63683d6d6173746572)](https://travis-ci.com/dmytro-demchyna/executor)[![Codecov](https://camo.githubusercontent.com/64919d4fe25e8faeeb8280f9c38c3dccf5e1b9e1877c9c1768ecdaece5d2edba/68747470733a2f2f636f6465636f762e696f2f67682f646d7974726f2d64656d6368796e612f6578656375746f722f6272616e63682f6d61737465722f6772617068732f62616467652e737667)](https://codecov.io/gh/dmytro-demchyna/executor)

The Executor helps to execute [PL/pgSQL](https://www.postgresql.org/docs/current/plpgsql.html) stored procedures.

Examples
--------

[](#examples)

### Exception handling

[](#exception-handling)

Suppose stored procedure throws an exception:

```
CREATE OR REPLACE FUNCTION public.test_function()
  RETURNS VOID
  LANGUAGE plpgsql
AS $function$
BEGIN
   RAISE EXCEPTION 'MyException' USING HINT = 'TestHint';
END;
$function$;

```

The way to call it via **Executor**:

```