PHPackages                             actimeo/pgproc - 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. actimeo/pgproc

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

actimeo/pgproc
==============

Call PostgreSQL PL/PgSQL procedures from PHP

4211PHP

Since Dec 27Pushed 9y ago1 watchersCompare

[ Source](https://github.com/actimeo/pgproc)[ Packagist](https://packagist.org/packages/actimeo/pgproc)[ RSS](/packages/actimeo-pgproc/feed)WikiDiscussions master Synced yesterday

READMEChangelogDependenciesVersions (1)Used By (0)

[![Build Status](https://camo.githubusercontent.com/4c13fdc0069ad4dbeda0eb5257d4f741372ff6a867ab2fdc4fda5f18f78834a5/68747470733a2f2f7472617669732d63692e6f72672f616374696d656f2f706770726f632e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/actimeo/pgproc)[![Coverage Status](https://camo.githubusercontent.com/37787cee3c6b2184a8aeddb6cfb134c38d1105c1f7c3f8939fa06454d722fc3f/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f616374696d656f2f706770726f632f62616467652e7376673f6272616e63683d6d617374657226736572766963653d676974687562)](https://coveralls.io/github/actimeo/pgproc?branch=master)

Install
=======

[](#install)

- Install with composer:

```
$ composer require actimeo/pgproc
```

- Create a database
- Import necessary code in your database:

```
$ cat vendor/actimeo/pgproc/src/sql/pgprocedures.sql | psql -h host -U login -W dbname
$ cat vendor/actimeo/pgproc/src/plpgsql/all.sql | psql -h host -U login -W dbname
```

Usage
=====

[](#usage)

- Write some procedures in your database, for example:

```
$ cat vendor/actimeo/pgproc/tests/tests.sql | psql -h host -U login -W dbname
```

```