How to get a list of words from a Full Text Search dictionary

Is there a way to query a dictionary using SQL in PostgreSQL, to get a list of words in that dictionary? I'm using Postgres 9.0.

Upvotes: 2

Answers (1)

Reputation: 7307

There is no built-in way I`m aware of, but assuming that You are using an aspell dictionary:

cat `pg_config --sharedir`/tsearch_data/english.dict |aspell -l en expand

Lists the words.

Upvotes: 2