[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: