file size about storage HOT 2 CLOSED

create view public.objects as
select
    name,
    created_at,
    updated_at,
    last_accessed_at,
    (metadata->'size')::int as size
from storage.objects;

$ curl -s -X GET 'https://your-app-id.supabase.co/rest/v1/objects' \
    -H "apikey: <anon key>" \
    -H "Authorization: Bearer <api key>" | jq
[
  {
    "name": "myfile",
    "created_at": "2021-10-05T17:48:27.045129+00:00",
    "updated_at": "2021-10-05T17:48:27.045129+00:00",
    "last_accessed_at": "2021-10-05T17:48:27.045129+00:00",
    "size": 6
  }
]

create view public.objects as
select
    name,
    created_at,
    updated_at,
    last_accessed_at,
    (metadata->'size')::int as size
from storage.objects OWNER TO authenticated;