Re: Replacement for Oracle Text - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: Replacement for Oracle Text
Date
Msg-id VisenaEmail.5.8f5d64f00e8d651c.152f95ba188@tc7-visena
Whole thread Raw
In response to Re: Replacement for Oracle Text  (Daniel Westermann <daniel.westermann@dbi-services.com>)
List pgsql-general
På fredag 19. februar 2016 kl. 12:41:49, skrev Daniel Westermann <daniel.westermann@dbi-services.com>:
>>Daniel Westermann schrieb am 19.02.2016 um 11:53:
>>> if I'd need to implement/replace Oracle Text (ww.oracle.com/technetwork/testcontent/index-098492.html).
>>>> What choices do I have in PostgreSQL (9.5+) ?

>Postgres also has a full text search (which I find much easier to use than Oracle's):
>
>http://www.postgresql.org/docs/current/static/textsearch.html

Yes, i have seen this. Can this be used to index and search binary documents, e.g. pdf ?
 
What we do is extract plain-text from PFD/Word etc. clientside in the application, and then index that in the database.
Works very well.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Replacement for Oracle Text
Next
From: Maxim Boguk
Date:
Subject: How to analyze locking issues of the startup process on hot standby replica?