Thread: functions, shell script
Can anyone give me an example of postgresql function that will execute a shell script?
I will call the function from a postgresql trigger.
Thanks.
Hello, You can't. You could write a C function that made a system call but you can not call to the shell directly. Sincerely, Joshua Drake http://www.postgresql.infop On Sun, 4 Nov 2001, Kenneth Skiles wrote: > Can anyone give me an example of postgresql function that will execute a shell script? > > I will call the function from a postgresql trigger. > > Thanks. > -- -- by way of pgsql-general@commandprompt.com http://www.postgresql.info/ http://www.commandprompt.com/
>Can anyone give me an example of postgresql function that will execute a >shell script? >I will call the function from a postgresql trigger. You need to create an untrusted language which I never did until now. For example, plpgsql functions are trusted, i.e. they cannot access the file system. I would be interested in knowing how to do it. Maybe it is possible with plperl or pltcl. Best regards, Jean-Michel POURE
Jean-Michel POURE wrote: > > >Can anyone give me an example of postgresql function that will execute a > >shell script? > >I will call the function from a postgresql trigger. > > You need to create an untrusted language which I never did until now. > For example, plpgsql functions are trusted, i.e. they cannot access the > file system. > > I would be interested in knowing how to do it. > Maybe it is possible with plperl or pltcl. > PL/TclU is untrusted (note the "U"). I never used it myself and I don't even know if it is working but maybe you could give it a try... (please let us know if it worked) -- Fernando Nasser Red Hat Canada Ltd. E-Mail: fnasser@redhat.com 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9
Kenneth Skiles writes: > Can anyone give me an example of postgresql function that will execute a shell script? > > I will call the function from a postgresql trigger. http://www.ca.postgresql.org/~petere/plsh.html -- Peter Eisentraut peter_e@gmx.net
>I will call the function from a postgresql trigger. >http://www.ca.postgresql.org/~petere/plsh.html Fabulous! /JMP