Count words and characters in a string with PostgreSQL

Count words and characters in a string with PostgreSQL

Count words

/* Count words separated by whitespaces */
SELECT ARRAY_LENGTH(REGEXP_SPLIT_TO_ARRAY(string_field, '\s'), 1)
  FROM your_table

Count characters

/* Count characters */
SELECT SUM(LENGTH(string_field))
  FROM your_table