Assuming you only plan on using ASCII encoding, a very viable option may be to use the Trigram (pg_trgm) module: http://www.postgresql.org/docs/9.0/interactive/pgtrgm.html (more…)
Archive for the ‘PostgreSQL’ Category
Partial Word Search / Spell Check in PostgreSQL 9 using Trigram (trgm)
Thursday, February 16th, 2012Full Text Search (FTS) in PostgreSQL 9.1 (Examples Included)
Monday, January 16th, 2012This post is aimed at providing only the information necessary to rapidly understand and deploy Full Text Search into your PostgreSQL environment. For more documentation, I’d recommend checking out the following URLs:
- http://linuxgazette.net/164/sephton.html
- http://www.postgresql.org/docs/9.1/static/textsearch.html
- http://www.slideshare.net/billkarwin/full-text-search-in-postgresql
Working with the hstore data type in PostgreSQL 9.0 / 9.1
Wednesday, November 30th, 2011This is a quick reference on how to install the HSTORE contrib module into your PostgreSQL database as well as a few example queries explaining how to interface with and query the HSTORE data type. (more…)
PostgreSQL and ODBC in 64-Bit Windows
Tuesday, September 20th, 2011(This document has been modified to instruct the setup of not only 64-bit systems, but 32-bit set ups as well.)
This tutorial is for individuals who are interested in setting up a DSN entry in their Data Sources (ODBC) for PostgreSQL. We cover both 32-bit and 64-bit versions of Windows, as each must be configured slightly differently.
(more…)
Python and PostgreSQL: A Quick Reference to psycopg2
Thursday, March 31st, 2011As with most database technologies I interact with, I like to throw together a few simple examples as reminders on how to interface with that technology. In this case we’re interfacing with the PostgreSQL database through the Python programming language. (more…)
PostgreSQL Quick Reference
Saturday, May 29th, 2010For those transitioning from other SQL database engines such as MSSQL or mySQL, I have put together this very simple quick reference for the most common of tasks.
(more…)