1. If this task would be easy, if this database is traditional setup like server with database so can use psql,pg_dump but since this is AWS-RDS.
2. We have don’t option to backup metadata in DBeaver or PGAdmin that’s makes this task trick so using PostgreSQL client libraries will be automatically installed on our pc’s.
   1. He is trick I followed to backup only metadata.

Open CMD to cd to this directory  à C:\Users\dbadeeds\AppData\Roaming\DBeaverData\drivers\clients\postgresql\win>

pg_dump.exe -F c -b -v -f C:\Users\dbadeeds\postgres\backup.dmp --exclude-table-data 'dbadeeds.t_*` --host=rds-xe1-dbadeeds -aurora.us-east-1.rds.amazonaws.com --port=5432 --username=dbadeeds -d dbadeeds_qa

1. Once backup is completed
2. Create database using DBeaver
3. Set active with new database and do right click restore option and source the above file.

https://dbeaver.io