On Wed, 2022-10-12 at 16:29 +0530, Nikhil Ingale wrote: > How do I take the backup of all the tables (no table data, no functions and other objects) only from one schema and restore to another schema?
Perform a dump with
pg_dump --schema=yourschema --schema-only dbname
Create a new database, restore the dump into the new database, rename the schema there, dump the new database and drop it, then import the new dump into the original database.