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 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,
  1. What is the relative path when running supabase start? Maybe I just have the wrong path in my migration script.
  2. Is there a better way I could be organizing my scripts/migrations?
Thanks for any help!
Was this page helpful?