pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Run external program from postgresql 4+ messages / 2 participants [nested] [flat]
* Run external program from postgresql @ 2012-05-17 14:39 francescoboccacci@libero.it <francescoboccacci@libero.it> 2012-05-17 14:49 ` Re: Run external program from postgresql Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 1 reply; 4+ messages in thread From: francescoboccacci@libero.it @ 2012-05-17 14:39 UTC (permalink / raw) To: pgsql-admin Hi all, i have a question. I'd like to create a trigger function that "call" and external application (es . C:\myprogram.exe) when a new row will be insert in a table. Is it possible? How can do that? Thanks Francesco ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Run external program from postgresql 2012-05-17 14:39 Run external program from postgresql francescoboccacci@libero.it <francescoboccacci@libero.it> @ 2012-05-17 14:49 ` Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabrízio de Royes Mello @ 2012-05-17 14:49 UTC (permalink / raw) To: pgsql-admin 2012/5/17 francescoboccacci@libero.it <francescoboccacci@libero.it> > Hi all, > i have a question. I'd like to create a trigger function that "call" and > external application (es . C:\myprogram.exe) when a new row will be insert > in a > table. > Is it possible? How can do that? > > Yes, it is. But you'll have to use an untrusted language like C, pl/python, pl/perl, etc. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Run external program from postgresql @ 2012-05-17 16:06 Fabrízio de Royes Mello <fabriziomello@gmail.com> 2012-05-17 16:08 ` Re: Run external program from postgresql Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 1 reply; 4+ messages in thread From: Fabrízio de Royes Mello @ 2012-05-17 16:06 UTC (permalink / raw) To: pgsql-admin 2012/5/17 francescoboccacci@libero.it <francescoboccacci@libero.it> > yes, thanks. I would like to intall pl/python in windows. Where i can find > this module? > > Thanks > > > I don't use Windows, so I never install pl/python in this plataform. But if you already install PostgreSQL in your machine I believe you could download the binaries zip package for windows [1]. After you download and extract the zip package you'll found the "plpython3.dll" file in the "lib" directory, then you must copy this file do the "lib" directory of your PostgreSQL installation ("c:\Program Files\PostgreSQL\9.1\lib") and you can try create language in your database: CREATE LANGUAGE plpythonu; or CREATE EXTENSION plpythonu; (9.1 version) Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Run external program from postgresql 2012-05-17 16:06 Re: Run external program from postgresql Fabrízio de Royes Mello <fabriziomello@gmail.com> @ 2012-05-17 16:08 ` Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 0 replies; 4+ messages in thread From: Fabrízio de Royes Mello @ 2012-05-17 16:08 UTC (permalink / raw) To: pgsql-admin 2012/5/17 Fabrízio de Royes Mello <fabriziomello@gmail.com> > > 2012/5/17 francescoboccacci@libero.it <francescoboccacci@libero.it> > > yes, thanks. I would like to intall pl/python in windows. Where i can find >> this module? >> >> Thanks >> >> >> > I don't use Windows, so I never install pl/python in this plataform. > > But if you already install PostgreSQL in your machine I believe you could > download the binaries zip package for windows [1]. > > After you download and extract the zip package you'll found the > "plpython3.dll" file in the "lib" directory, then you must copy this file > do the "lib" directory of your PostgreSQL installation ("c:\Program > Files\PostgreSQL\9.1\lib") and you can try create language in your database: > > CREATE LANGUAGE plpythonu; > > or > > CREATE EXTENSION plpythonu; (9.1 version) > > You'll must install Python [1] for windows too. [1] http://www.python.org/download/releases/ -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-05-17 16:08 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-05-17 14:39 Run external program from postgresql francescoboccacci@libero.it <francescoboccacci@libero.it> 2012-05-17 14:49 ` Fabrízio de Royes Mello <fabriziomello@gmail.com> 2012-05-17 16:06 Re: Run external program from postgresql Fabrízio de Royes Mello <fabriziomello@gmail.com> 2012-05-17 16:08 ` Fabrízio de Royes Mello <fabriziomello@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox