we can do using pg_dump finding out the file named there and export it using datagripp, and we can also do backup using pgadmin
once you created the tables in pgadmin, using dbeaver and importing data to each table one by one
using database, then choosing tools, then backup will export the database as sql