1.1 安装plpython 在windows环境
1.1.1 下载http://legacy.python.org/ftp//python/3.2.5/python-3.2.5.msi 并安装,POSTGRESQL9.3 版本必须用python3.2版。
1.1.2 复制C:\Python32\DLLs\python3.dll到C:\Program Files (x86)\PostgreSQL\9.3\lib下,并改名为python32.dll
1.1.3 执行命令:CREATE EXTENSION plpython3u;或
-- Extension: plpython3u
-- DROP EXTENSION plpython3u;
CREATE EXTENSION plpython3u
SCHEMA pg_catalo VERSION "1.0";
1.1.4
查看执行结果:
SELECT * FROM pg_available_extensions WHERE name LIKE '%python%' ORDER BY name;
如图,表示python3安装成功
安装成功后,pgadmin上出现
1.1.5
执行python语言的例子
DROP FUNCTION
test_fn(a integer, b integer);
CREATE OR REPLACE FUNCTION
test_fn(a integer, b integer)
RETURNS text AS $$
result
= object()
import
pickle
return
pickle.dumps({'a':a, 'b':b})
$$ LANGUAGE plpython3u
SELECT test_fn(1,2)
参考资料:
http://www.youlikeprogramming.com/2013/08/postgresql-9-1-installing-plpythonuplpython3u-python-in-windows/