Contents

WITH

denormalized AS (
  SELECT
    jsonb_array_elements(data)->>'table_name' as table_name,
    jsonb_array_elements(data)->>'au' as au,
    jsonb_array_elements(data)->>'eu' as eu,
    jsonb_array_elements(data)->>'us' as us
  FROM table_counts
)
select * from denormalized order by table_name

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
rails_app_generator-0.3.6	after_templates/application/klueless/db/views/table_count_entries_v01.sql
rails_app_generator-0.3.5	after_templates/application/klueless/db/views/table_count_entries_v01.sql
rails_app_generator-0.3.4	after_templates/application/klueless/db/views/table_count_entries_v01.sql
rails_app_generator-0.3.3	after_templates/application/klueless/db/views/table_count_entries_v01.sql
rails_app_generator-0.3.2	after_templates/application/klueless/db/views/table_count_entries_v01.sql