#!/bin/sh
psql sheet -XAt -c "
- SELECT json_object_agg(coalesce(form, ''), forms)
- FROM word RIGHT JOIN (
- SELECT cat id, array_agg(form ORDER BY form) forms
- FROM word WHERE ref IS NULL GROUP BY cat
- ) sub USING (id)
+ SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
" | sed 's/:/=>/g'