8 lines
292 B
Text
8 lines
292 B
Text
# 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;
|