Re: Run external program from postgresql - Mailing list pgsql-admin

From Fabrízio de Royes Mello
Subject Re: Run external program from postgresql
Date
Msg-id CAFcNs+pDMRshGOwtmzQxTBtnZTWJiT34cTiRjz7+OLdZVnU7NA@mail.gmail.com
Whole thread Raw
In response to Re: Run external program from postgresql  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List 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.


--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

pgsql-admin by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Run external program from postgresql
Next
From: "Little, Douglas"
Date:
Subject: Transaction ID overrun problem on greenplum