Search Postgresql Archives

Re: Replacement for Oracle Text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 20/02/16 00:24, Bruce Momjian wrote:
On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:
On 19 February 2016 at 14:19, Bruce Momjian <bruce@xxxxxxxxxx> wrote:
     >     Ah, no. That's not possible
     >
     >
     > ...not possible, Yet.
     >
     > PostgreSQL grows by adding the features people need and its changing
     rapidly.

     I wonder if PLPerl could be used to extract the words from a PDF
     document and create a tsvector column from it.

  I don't know about PLPerl(I'm pretty sure it could be used for this purpose,
though.).  On the other hand I've written code for this in Python which should
be easy to adapt for PLPython, if necessary.

Right, so you would write a PL/Perl or PL/Python trigger function that
would populate the tsvector column on every INSERT or UPDATE.

FWIW, I just use pdftotext in my CGI.

--
=============================================================================
Stephen Davies Consulting P/L                             Phone: 08-8177 1595
Adelaide, South Australia.                                Mobile:040 304 0583


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux