PostgreSQL 9.1: Installing plpythonu/plpython3u (Python) in Windows

Postgre SQL 前端之家
前端之家收集整理的这篇文章主要介绍了PostgreSQL 9.1: Installing plpythonu/plpython3u (Python) in Windows，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

Postgresql 9.1: Installing plpythonu/plpython3u (Python) in Windows

Install plpython3u

If you're lucky,the following command will just work,and the Python language has been successfully installed:

Select All 
1

CREATE EXTENSION plpython3u;

If you encounter the following error:

1 
ERROR:  could not load library "C:/Program Files/Postgresql/9.1/lib/plpython3.dll": The specified module could not be found.

We have a little more work to do.

Postgresql 9.1 requires a VERY specific sub-version of the Python DLL: Python 3.2.x. (availablehere) Any other version (3.1.x,3.3.x,or otherwise) will cause the installation of plpython3u to fail. In addition,Postgresql 9.1 unfortunately does not appear to ship with Python 2.x support either.

If Python 3.2.x is not installed,download and install it.

Browse to your Python 3.2.x installation directory. By default,this should be something similar to: C:\Python32. From here,navigate to theDDLsdirectory and locate a DLL namedpython3.dll.

In a separate window,browse to you Postgresql installation directory. By default,this should be something similar to: C:\Program Files\Postgresql\9.1. From there,navigate into thelibdirectory and copy the python3.dll from the other window into this directory. Rename the copied DLL from python3.dll topython3@H_403_55@2.dll.

Finally,attempt to run the CREATE EXTENSION command again:

CREATE EXTENSION plpython3u;

This time,you should receive the expected result; signalling the installation was successful.

CREATE EXTENSION

Testing Your plpython3u Extension

First,we need a stored procedure which utilizes the Python language:

1 2 3 4 5 6 7 
DROP FUNCTION test_fn(a integer, b integer);
CREATE OR REPLACE )
RETURNS text AS $$
	result = object()
	import pickle
	return pickle.dumps({'a':a, 'b':b})
$$ LANGUAGE plpython3u

Now,let's query our new function:

SELECT test_fn(1,2)

You should receive a response similar to the following:

b'\x80\x03}q\x00(X\x01\x00\x00\x00aq\x01K\x01X\x01\x00\x00\x00bq\x02K\x02u.'
原地址 http://www.youlikeprogramming.com/2013/08/postgresql-9-1-installing-plpythonuplpython3u-python-in-windows/ 原文链接：https://www.f2er.com/postgresql/195818.html

猜你在找的Postgre SQL相关文章

PosegreSQL基础回顾(第 4 章 SQL语法)
来源：http://www.postgres.cn/docs/11/ 4.1.1. 标识符和关键词 SQL标识符和关键...
PosegreSQL基础回顾(第 8 章 数据类型)
来源：http://www.postgres.cn/docs/11/ 8.1. 数字类型 数字类型由2、4或8字节的...
PosegreSQL基础回顾(第 5 章 数据定义)
来源：http://www.postgres.cn/docs/11/ 5.1. 表基础 SQL并不保证表中行的顺序。...
PosegreSQL基础回顾(第 6 章 数据操纵、第 7 章 查询)
来源：http://www.postgres.cn/docs/11/ 6.4. 从修改的行中返回数据 有时在修改行...
PosegreSQL基础回顾(第 13 章 并发控制)
来源：http://www.postgres.cn/docs/11/ 13.2.1. 读已提交隔离级别 读已提交是Po...
PostgreSQL安装和使用
青岛OJ系统用的关系型数据库是PostgreSQL,为此对PostgreSQL大致了解下。 今天的主要话题围...
PostgreSQL整体架构
 
为什么选择PostgreSQL而不是MySQL
David Bolton是一名独立开发者，他使用PostgreSQL和MySQL都已有超过十年的时间。近日，他撰...
为什么选择PostgreSQL而不是MySQL
David Bolton是一名独立开发者，他使用PostgreSQL和MySQL都已有超过十年的时间。近日，他撰...
专访唐成：从小工到专家，PostgreSQL的修炼之道
唐成，拥有十几年数据库、操作系统、存储领域的工作经验。目前任沃趣科技首席数据库架构师...
MySQLMsSQLOracleSqlitePostgre SQLMariadbMongoDBNoSQLHBaseJDBC
undo日志persistent-cmysql-error-postal-codesql-match-almysql-5.6mysql-8.0database-tri安装路径系统错误data_dir丢失文件主从同步sql_mode数据库目录匿名用户character_seID归零数据库位置查询表重复字段查询字段截断日志SUSPECT7391Remote ServeLinked Serve玄学问题登录不上开启远程访问