# First read in the file as a single row in a table:
create or replace table t as (select content from read_text('unixdict.txt'));

# Use GROUP BY to create the table
select c, count(*) as count
  from (select unnest(regexp_extract_all((from t), '.')) as c)
  group by c
  order by count, c;