Supabase Environments

Hi All - I have created a new project, and connected it to supabase - in environments, I have only tagged it to dev environment. I am a little confused as to how the preview branching etc. would work - and if I were to create another database for prod - how do I connect that to this project so if I pull request into main from my dev branch - the changes are migrated to new database?

When I am deploying it, despite selecting preview in v0, it still does production deploy!

Or am I approaching it the wrong way - I have seen the video and it talks about local development and not very clear for v0 scenario, where we want to build a CI/CD pipeline!