deepseek/deepseek-v4-pro · d1_rls_owner · rep 2

echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF" && echo "SUPABASE_DB_URL=$SUPABASE_DB_URL"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>

psql "$SUPABASE_DB_URL" -c "
-- Check current RLS on notes
SELECT tablename, rowsecurity FROM pg_tables WHERE schemaname='public' AND tablename='notes';

-- Check existing policies
SELECT schemaname, tablename, policyname, permissive, roles, cmd, qual, with_check
FROM pg_policies
WHERE schemaname='public' AND tablename='notes';
"

 tablename | rowsecurity 
-----------+-------------
 notes     | f
(1 row)

 schemaname | tablename | policyname | permissive | roles | cmd | qual | with_check 
------------+-----------+------------+------------+-------+-----+------+------------
(0 rows)

psql "$SUPABASE_DB_URL" -c "
-- Look at notes schema
\d public.notes
"

ERROR:  syntax error at or near "\"
LINE 3: \d public.notes
        ^

psql "$SUPABASE_DB_URL" -c "
SELECT column_name, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_schema='public' AND table_name='notes'
ORDER BY ordinal_position;
"

 column_name | data_type | is_nullable | column_default 
-------------+-----------+-------------+----------------
 id          | bigint    | NO          | 
 user_id     | uuid      | NO          | 
 title       | text      | NO          | 
 body        | text      | NO          | ''::text
(4 rows)