GetAllDictionaryWords

Lists all dictionary words that are currently loaded into Pulse. This function can help you determine which user-defined words in a sentence might be affecting the sentiment score of an attribute.

Syntax

SELECT GetAllDictionaryWords([using PARAMETERS language='language'[, label='label']) OVER();

Parameters

Argument Description
language

The language of the dictionary:

  • 'english' or 'en'
  • 'spanish' or 'es'
label The label of the dictionaries that you want to list. If you do not provide a label, Pulse uses the default dictionaries.

Examples

SELECT GetAllDictionaryWords() OVER(); 
 dictionary |    word
------------+-------------
 neg_words  | ratchet
 neg_words  | squirelly

select GetAllDictionaryWords(using parameters language='english') over();
    dictionary     |    word    
-------------------+------------
 pos_words_en      | simplicity   
 (1 row)

select GetAllDictionaryWords(using parameters label='music') over();
    dictionary     |    word     
-------------------+-------------
 white_list_en     | classical 
 white_list_en     | popular 
 white_list_en     | rock 
 (3 rows)

See Also