retrieving keys from a GIN index on a tsvector column in Postgres 9.1?

From: Chris Esposito <chris(dot)esposito(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: retrieving keys from a GIN index on a tsvector column in Postgres 9.1?
Date: 2012-10-18 19:13:59
Message-ID: CAF6hsPjHgoHWgsH62JbTiZnqHP0-JqZS7xzVyS+pMC6AfLx4bQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've got a collection of documents that I'd like to do some full text
searching on in Postgres 9.1, so adding them as the contents of a tsvector
and then creating a GIN index on this column seems straightforward enough.
My understanding of the GIN index is that the keys used are (depedning on
the text search configuration used) either the list of original words or
their normalized lexemes from the collection of original documents.
However, for other functionality we've developed I'd really like to get
that list of keys out of the GIN index to put in another column in a
different table for use. Is this possible?

Thanks,
Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-10-18 20:09:09 Re: pg_stats in 9.2
Previous Message Raymond O'Donnell 2012-10-18 17:38:00 Re: postgresql error while connecting to cluster with pgadmin