Re: [HACKERS] executing OS programs from pg

2005-06-04 Thread Hans-Jürgen Schönig
Gevik babakhani wrote: Dear people, Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Does such functionality exist or do I have to write my own trigger function in C. Reagrds, Gevik.

Re: [HACKERS] executing OS programs from pg

2005-06-04 Thread Christopher Kings-Lynne
Try the PL/sh project on www.pgfoundry.org. Chris Gevik babakhani wrote: Dear people, Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Does such functionality exist or do I have to

[HACKERS] executing OS programs from pg

2005-06-03 Thread Gevik babakhani
Dear people, Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Does such functionality exist or do I have to write my own trigger function in C. Reagrds, Gevik.

Re: [HACKERS] executing OS programs from pg

2005-06-03 Thread Tom Lane
Gevik babakhani [EMAIL PROTECTED] writes: Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Use any of the untrusted PLs to execute system() or the like. Whether this is a good idea or not is a

Re: [HACKERS] executing OS programs from pg

2005-06-03 Thread Bruno Wolff III
On Fri, Jun 03, 2005 at 20:56:44 +0200, Gevik babakhani [EMAIL PROTECTED] wrote: Dear people, Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Does such functionality exist or do I

Re: [HACKERS] executing OS programs from pg

2005-06-03 Thread John Hansen
: [HACKERS] executing OS programs from pg Gevik babakhani [EMAIL PROTECTED] writes: Does anyone know how to execute an OS command from pgsql. I would like to create a trigger that op on firing would run/execute an external program. Use any of the untrusted PLs to execute system