Search code examples
supabasesupabase-database

How i can pull all data project production to local enviroment in supabase


I have created a project using supabase platform directly and not in local enviroment so all tables are in production, but now i need a local enviroment for development o test so i created a local project using this guide but the project is from scracth, the question is ¿how i can pull all tables from production to local enviroment?

Local guide


Solution

  • You can do this by using pgdump to export the table schema and importing it back into your local environment. You can follow this guide https://supabase.com/docs/guides/platform/migrating-and-upgrading-projects