Full text search using postgresql-8.4 and django

Question

Full text search with mysql & django can be done using following django api query

Entry.objects.filter(headline__search="search text")

This returns result set properly.But this can't be used with postgresql, while using getting an exception which is shown below

Full-text search is not implemented for this database backend

How can i imlement full text search with postgresql & django which is same as that of django-mysql full text search?

Rohan · Accepted Answer · 2013-04-09 05:16:40Z

4

You can try

Entry.objects.filter(headline__contains="search text")

or __icontains for case-insensitive search.

As the django doc says __search only works with MySQL for now.

answered Apr 9, 2013 at 5:16

Rohan

53.5k12 gold badges96 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

@ Rohan,This query returns the result set which having exact match, Is there any option for including partial match also?

@Jafarali, I don't think __contains does exact match (ref : docs.djangoproject.com/en/dev/ref/models/querysets/#contains), for exact match you need to use __exact. However, it would check for both (all) words given to look for.

@ Rohan,Suppose checking for a match against the record "welcome to the new world" with query __contains="welcome world" , returns zero records.

Psion · Accepted Answer · 2013-11-13 11:45:08Z

2

answered Nov 13, 2013 at 11:45

Psion

1054 bronze badges

Paolo Melchiorre · Accepted Answer · 2017-09-04 06:37:09Z

0

For user reading this question these days:

PostgreSQL Full-Text-Search support is present since Django 1.10 (2016) by the module django.contrib.postgres.search .

answered Sep 4, 2017 at 6:37

Paolo Melchiorre

6,1733 gold badges35 silver badges53 bronze badges