migrations - schema and data best practise

Hi everyone. I am new to both pgsql and supabase. I’ve been looking into the superbase cli migrations feature, and found out while it migrates schema, it doesn’t do the content - namely in a test database, it seemed to empty the whole table (I may have done it wrong and I will double check later but I believe this to be accurate).

In the general world of pgsql, what’s the best set of tools to use for schema migrations that handle content (i.e adding a new column with a default value to an existing table - basic stuff)
Was this page helpful?