How to load Additional Supplied Modules for Postgres on Windows
来源:互联网 发布:网络电视盒多少钱 编辑:程序博客网 时间:2024/05/18 01:15
I try to enable "fuzzystrmatch" function in Postgresql 8.3.9, following is my solution:
- DO NOT install Postgresql under the default "Progrem File" directory, because the it can't not recognize the white space inside the path! I switch to some directory not containing while space, like "C:/PostgreSQL/8.3/". I will use this as my Postgres home directory. I install and reinstall several times and figure out this isssue. Actually. it is a very common problem using software ported form Linux world.
- You will find lots of DLL files under "lib". But we should go to "share/contrib" directory. Run:
- C:/PostgreSQL/8.3/bin>psql -d postgres -U postgres -f C:/PostgreSQL/8.3/share/contrib/fuzzystrmatch.sql
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
- C:/PostgreSQL/8.3/bin>psql -d postgres -U postgres -f C:/PostgreSQL/8.3/share/contrib/fuzzystrmatch.sql
- You should note that this funtion must be specified to any database you want. It is not a global setting! Then try SELECT levenshtein('GUMBO', 'GAMBOL'); or SELECT name FROM element WHERE difference(name, 'item') > 2;
- If you want to check out more fuzzy search, go to reference [1]. There will be another solution, please refer to [2].
- Next, I will try xml and full-text search functions.
Reference:
[1]http://www.postgresql.org/docs/8.3/static/fuzzystrmatch.html
[2]http://stackoverflow.com/questions/430123/how-do-i-enable-the-postgresql-function-profiler
[3] FAQ on installation for Windows: http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows
[4] Thanks this page poniting out the right location for the sql file: http://dcmms.sourceforge.net/doc/administration/index.html#fuzzystrmatch_manual_install
- How to load Additional Supplied Modules for Postgres on Windows
- How to write Makefile for kernel modules
- How to Create, Compile, Load Linux LKM Loadable Kernel Modules
- HOWTO build additional kernel modules for Android
- How to do synchronization for Tomboy Notes on Windows
- How to Set Classpath for Java on Windows and Linux
- How to install Windows on your Mac for free
- How to compile kernel modules for the kernel 2.6
- How to Enable Plain Text Password on Windows for Connecting to Samba Server
- How to Load XML with JavaScript on an HTML5 Page
- How to Install PHP 5 for Iis 6 on Windows Xp and 2003 - wikiHow
- How to install and run Microsoft Windows for free on Linux
- How to read calllogs on windows mobile
- How to compile x264 on Windows?
- How to install GTK+ on windows
- How to compile x264 on Windows
- How to install Maven on Windows
- how to use python virtualenv on windows
- 提高C#编程水平的50个要点
- 买房和投资,透支未来与理财(ZT)
- Emacs
- PASCAL实现二进制字符串转十进制字符串
- asp.net根据登陆名分配权限
- How to load Additional Supplied Modules for Postgres on Windows
- AJAX 怎样在一个UpDatePanel中刷新另一个updatePanel (asp.net C#)
- 如何学习软件测试?How to study software testing?
- 啊
- IBM为Android设备添加Lotus Notes客户端
- 2003 下oracle10 创建数据库
- .net实现的随机数均匀分布
- 一些高效的Linux命令行操作
- C语言的inline