Any reason why I'd get this with a postgres database

ERROR: relation "public.User" does not exist

@Jose Garcia check that you have set the schema/database for your postgres. If you're using prisma 2, make sure you have run prisma2 lift up to apply any migrations to your postgres table