Truncate DB Postgresql

I accidentally emptied a table from my database using the TRUNCATE command.

Is there any way of recovering the contents, or are backups made?

Hey @gherbiyaminy. If you’re using Vercel Postgres, automated backups are not currently supported.

You can use pg_dump to import a Postgres database into your Vercel Postgres if you have a copy of the data saved somewhere. The postgres connection environment variables created in your Vercel project can be used to define the connection string for pg_dump.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.