Fly.io Database - Push schema

Hello,

My website says that “The table ‘public.PostRead’ does not exist in the current database.” although it is in my schema.prisma. Does anybody know how to fix this?

1 Like

Hi tom2, if you are using the fly postgres offering, you can connect to the database directly using:

fly pg connect -a <fly pg app name>

That will drop you into a psql interface. From there you can see what databases, schemas, etc exist.

If you are running your own db, fly ssh console to the db app and then connect the db using whatever client works locally for a similar experience.