#!/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)
-" | sed 's/:/=>/g'
+ SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
+" | sed 's/ : / => /g'