Re: Executing External Programs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Is there a way (maybe creating a function) to execute an external program
> from within postgre with a query?

You will need to create a function written in a procedural language. The best
ones to do this is probably PL/Tcl or PL/Perl. Both come bundled with Postgres,
and are fairly easy to learn and use, especially if you have tcl or perl experience.

Information on installing languages:
http://www.postgresql.org/docs/view.php?version=7.3&file=xplang-install.html

Information on PL/Tcl:
http://www.postgresql.org/docs/view.php?version=7.3&file=pltcl.html
(you probably want "untrusted": PL/TclU)

Information on PL/Perl:
http://www.postgresql.org/docs/view.php?version=7.3&file=plperl.html

Again, you may need the "untrusted" version, PL/PerlU:
http://www.postgresql.org/docs/view.php?version=7.3&file=plperl-trusted.html

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200305200935
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+yjKQvJuQZxSWSsgRAo1WAKCw9UyE5lrqAnm+erspeRmr5BDwcwCg/PTP
uet5zwqP1/ZTvN1+8za5SNI=
=tc3u
-----END PGP SIGNATURE-----