Migrate data from production retool database to other environemnts


Is there a way to create a database dump and restore it into different environments? I successfully connected to Retool database via PgAdmin, but I'm not able to fully restore a backup due to permissions. I just want to replicate the data available in 1 environment into another.