`
javababy1
  • 浏览: 1220282 次
  • 性别: Icon_minigender_1
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

How to load Additional Supplied Modules for Postgres on Windows

阅读更多

I try to enable "fuzzystrmatch" function in Postgresql 8.3.9, following is my solution:

  1. 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.
  2. 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
  3. 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;
  4. If you want to check out more fuzzy search, go to reference [1]. There will be another solution, please refer to [2].
  5. 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

分享到:
评论

相关推荐

    Mask 98 for PRwin98

    PRWIN98.HLP Online help for Mask for Windows - PRWin98. PRWIN98.LIC License Agreement for Mask for Windows - PRWin98. TOOLHELP.DLL Windows' tool-helper functions module. README.TXT General ...

    dbExpress driver for Oracle v6.2.3

    dbExpress is a database-independent layer that defines common interface to provide fast access to Oracle from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. For ...

    dbExpress driver for PostgreSQL v3.2.3

    dbExpress is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms....

    英文原版-Beginning SUSE Linux From Novice to Professional 1st Edition

    You’ll learn how to master the command-line prompt, secure your system, and perform administration tasks like scheduling backups and managing users.A full version of the SUSE operating system is ...

    Windows版libxml2.7.8

    For example, if you want to run the supplied utilities from the command line, you can, if you wish, add the 'bin' subdirectory to the PATH environment variable. If you want to make programmes in C ...

    USBlyzer-破解版

    USBlyzer is an easy to use software USB protocol analyzer for Windows, which provides a complete yet simple to understand view for analyzing USB Host Controllers, USB Hubs and USB Devices activity. ...

    vmware unlocker 2.0.6最新版(vm虚拟机破解安装Mac OS)

    You will have to manually mount the darwin.iso for example on Workstation and Player. The vmwarebase code does not need to be patched on OS X or ESXi so you will see a message on those systems ...

    pja_2.5.zip

    When no X11 Display is available on a UNIX machine (also called headless environment) or when GDI resources are low on Windows, it is impossible to compute off-screen images with java.awt.Graphics ...

    Advanced Apple Debugging & Reverse Engineering v0.9.5

    In this chapter, you'll learn additional ways DTrace can profile code, as well as how to augment existing code without laying a finger on the actual executable itself. 27. DTrace vs objc_msgSend In ...

    MinGW full 2009-04-10 Windows下的GNU编译器

    Primarily intended for use by developers working on the native MS-Windows platform, but also available for cross-hosted use, (see note below -- you may need to follow the "read more" link to see it), ...

    macOS Unlocker 2.1 for VMware Workstation 11/12/14(VM14破解补丁)

    You will have to manually mount the darwin.iso for example on Workstation 11 and Player 7. The vmwarebase code does not need to be patched on macOS or ESXi so you will see a message on those systems ...

    unlocker208 —— VMware 安装 MacOS的必备补丁

    You will have to manually mount the darwin.iso for example on Workstation 11 and Player 7. The vmwarebase code does not need to be patched on OS X or ESXi so you will see a message on those systems ...

    BS ISO 20417:2021 Medical devices - Information to be supplied b

    《BS ISO 20417:2021 医疗器械 - 制造商需提供的信息》标准是国际标准化组织(ISO)与英国标准协会(BSI)联合制定的一项重要规范,旨在确保医疗器械在设计、制造和使用过程中提供充分、准确的信息,以保障患者安全...

    Python for Signal Processing

    with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of ...

    Senfore_DragDrop_v4.1

    to ask for help via email, but I cannot guarantee that I will have time to help you or even reply to your mail. If you absolytely can't live without my help, you can alway try bribing me. You can ...

    BS ISO 20417-2021 Information to be supplied by the manufacturer

    BS ISO 20417-2021 Medical devices — Information to be supplied by the manufacturer.pdf

    Introduction.To.Algorithms,.Second.Edition

    We have supplied an extensive bibliography and pointers to the current literature. Each chapter ends with a set of "chapter notes" that give historical details and references. The chapter notes do not...

    An Introduction to Statistical Learning with Applications in R

    Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer ...

    Pro Multithreading and Memory Management for iOS and OS X

    supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted ...

Global site tag (gtag.js) - Google Analytics