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

1k Views Asked by At

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.

1

There are 1 best solutions below

0
On

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.