mirror of
https://github.com/barthuijgen/factorio-sites.git
synced 2024-12-11 11:41:28 +02:00
6 lines
218 B
SQL
6 lines
218 B
SQL
CREATE OR REPLACE VIEW public.blueprint_items
|
|
AS
|
|
SELECT distinct UNNEST(ARRAY(SELECT jsonb_object_keys(data -> 'items'))) as item FROM blueprint;
|
|
|
|
ALTER TABLE public.blueprint_items
|
|
OWNER TO "factorio-blueprints"; |