Referencing file in Migration
Hi, this might be more of a postgres question but I'm trying to organize my scripts in a way to where say I want to reference or update a table, I could just alter the sql file at say
Two questions,
supabase/tables/table_name.sql. To add this table in my DB, I run a new migration with the line \i supabase/tables/table_name.sql but I'm getting Error: Error starting database: supabase/tables/table_name.sql: No such file or directory when I try to spin up Supabase.Two questions,
- What is the relative path when running
supabase start? Maybe I just have the wrong path in my migration script. - Is there a better way I could be organizing my scripts/migrations?