list layers for schema

layer_column_list.sql

with one as (
    select nspname, relname, json_build_object(attname, typname) column_info from pg_catalog.pg_class
    join pg_catalog.pg_namespace on relnamespace = pg_namespace.oid
    join pg_catalog.pg_attribute on attrelid = pg_class.oid
    join pg_catalog.pg_type on atttypid = pg_type.oid
    where nspname = 'cart2wheel2' and relkind = 'r' and attnum > 0
),
two as (
select nspname, relname, array_to_json(array_agg(column_info)) column_info from one
group by 1,2
)
 select array_to_json(array_agg(row_to_json(two.*))) from two