pl/pgsql question
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Rhys
Peace & Love | Live Long & Prosper
Two options I have run across.
pl/sh
http://developer.postgresql.org/~petere/pgplsh/
ShellSQL
http://www.edlsystems.com/shellsql/
On Friday 12 May 2006 07:54 am, Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?Rhys
Peace & Love | Live Long & Prosper
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
Adrian Klaver
aklaver@comcast.net
On Friday 12 May 2006 10:54 am, "Rhys Stewart" <rhys.stewart@gmail.com> thus
communicated:
--> hi all,
--> are there any function in pl/pgsql to call a shell script? or like is
--> there a pl/bash?
-->
You can use Perl in "untrusted" mode as a backend function and accomplish
something like that.
On Fri, May 12, 2006 at 09:54:23AM -0500, Rhys Stewart wrote:
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
PL/sh might be what you're after; you could also use PL/Perl, etc.
http://pgfoundry.org/projects/plsh/
What does the shell script do? Having the database invoke external
actions isn't always a good idea; for example, if the transaction
rolls back then you can't undo those actions. Some problems are
better solved with LISTEN/NOTIFY because notifications don't go out
unless and until the transaction commits.
--
Michael Fuhr
Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Actually scary enough, there is pl/bash. Google is your friend. You can
also use:
plpython, plperl, plphp, pljava etc...
Joshua D. Drake
Rhys
Peace & Love | Live Long & Prosper
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/