Storage Helper Functions
Learn the storage schema
Supabase Storage provides SQL helper functions which you can use to write RLS policies.
storage.filename()
Returns the name of a file. For example, if your file is stored in public/subfolder/avatar.png
it would return: 'avatar.png'
Usage
This example demonstrates how you would allow any user to download a file called favicon.ico
:
storage.foldername()
Returns an array path, with all of the subfolders that a file belongs to. For example, if your file is stored in public/subfolder/avatar.png
it would return: [ 'public', 'subfolder' ]
Usage
This example demonstrates how you would allow authenticated users to upload files to a folder called private
:
storage.extension()
Returns the extension of a file. For example, if your file is stored in public/subfolder/avatar.png
it would return: 'png'
Usage
This example demonstrates how you would allow restrict uploads to only PNG files inside a bucket called cats
: