Bug#412532: ITP: postgresql-plsh -- PL/sh procedural language for PostgreSQL.
Package: wnpp
Severity: wishlist
Owner: Filipe Lautert <filipe@icewall.org>
* Package name : postgresql-plsh
Version : 1.2
Upstream Author : Peter Eisentraut <petere@postgresql.org>
* URL : http://plsh.projects.postgresql.org/
* License : BSD
Programming Lang: C
Description : PL/sh procedural language for PostgreSQL
PL/sh is a procedural language handler for PostgreSQL that allows you
to write stored procedures in a shell of your choice. For example,
CREATE FUNCTION concat(text, text) RETURNS text AS '
#!/bin/sh
echo "$1$2"
' LANGUAGE plsh;
The first line must be a #!-style line that indicates the shell to
use. The rest of the function body will be executed by that shell in
a separate process.
The shell script can do anything you want, but you can't access the
database. Trigger functions are also possible, but they can't change
the rows.
-- System Information:
Debian Release: 4.0
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-3-k7
Locale: LANG=pt_BR, LC_CTYPE=pt_BR (charmap=ISO-8859-1) (ignored: LC_ALL set to pt_BR)
Reply to: