Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hi there,
At sign-up I add a `tenant_id` field (which is an integer) to the new user's `app_metadata`, and I need to use this in row-level security policy.
I can't figure out the syntax for accessing this in the policy statement. I thought it would be something like this:

```SQL
BEGIN;
  ALTER POLICY "Enable tenant-based access" ON "public"."test" USING (tenant_id = (auth.jwt().app_metadata -> 'tenant_id'::integer));
COMMIT;
```

But I get a syntax error. Any ideas? Thanks!

I tried this:
```
tenant_id = (auth.jwt().app_meta_data ->> 'tenant_id')::integer
```
and this:
```
tenant_id = ((auth.jwt() ->> 'app_meta_data')::jsonb ->> 'tenant_id')::integer
```
The first gives a syntax error, the second is accepted but doesn't work.  😕

Got it!
```SQL
tenant_id = ((auth.jwt()->>'app_metadata')::jsonb->>'tenant_id')::integer
```