PL/php¶

Welcome to the PL/php site. PL/php is a procedural language add-on for PostgreSQL, which means you can define PHP functions that run inside a PostgreSQL server.

Obtaining PL/php¶

Please see the Downloads page. Or you can get the latest sources using anonymous svn access:

svn checkout https://projects.commandprompt.com/public/plphp/repo/trunk

Documentation¶

Please see the PLphp Installation procedures.

Before you can use PL/php, you need to create the language] in the database (In [[PostgreSQL 80 you need [wikiCreateLang80 these instructions instead]]).

Usage Documentation: PLphp User Guide

Contributed Documentation¶

Ribamar has also translated this documentation to Portuguese: http://pg.ribafs.net/content/view/29/30/

Ribamar Sousa has written a tutorial about installing PL/php on Ubuntu and PostgreSQL 8.3 (in Portuguese):
http://pg.ribafs.net/content/view/27/30/

Santiago Zárate has documented the installation for Ubuntu in Spanish:
http://blog.santiago.zarate.net.ve/archives/1-Como-instalar-plphp-en-ubuntu-7.04-y-7.10

Support¶

You can join the mailing list.

Or you can reach us on Freenode at the #plphp channel.

Release History¶

10/15/2007:

PL/php 1.3.5 Beta1 addresses PostgreSQL 8.3Beta1 compatibility and named parameters

---

PL/php 1.3.3 addresses the previous phpinfo() issue as well as a bunch of others, particulary improper handling of columns with numeric names, random backend crashes etc. This is the first PL/php version with PostgreSQL 8.2 support, and autoconf/configure scripts replacing the need to edit the project's Makefile directly. It still has issues with threaded PHP build, so I recommend not using --enable-maintainer-zts when configuring your PHP library. Except for this it successfully passed all regression tests with PostgreSQL 8.2 and PHP 5.

----
PL/php 1.3 was released on 2006-07-14. It is virtually identical to 1.2. There is a bug that prevents phpinfo() from working. It does not support in/out parameters.
----
PL/php 1.2 was released on 2005-12-13. This version adds SRF (Set-Returning Function) support. It is also an attempt to make the build system a bit more independent of your actual setup. In order to build it, you need to have the apxs program somewhere in your path. Please report any incompatibility.
----
PL/php 1.1 was released on 2005-12-05. This version is much cooler than the previous one because you don't have to patch PostgreSQL nor PHP sources -- actually, you don't even need those sources, so it's much easier to install than the previous 1.0 version. This is the first release since I (Álvaro Herrera) took maintainership of PL/php.