Without dropping the schema and recreating the schema, you need to clean /drop all the database objects from the same schema manually if you are looking work without dropping the schema.
Thanks,
Sarwar
From: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 2:41 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Login script
Hi All,
Do We have any script to recreate specific schema users before we start any schema refresh from prod to UAT ?
I need to script out all logins with permissions and roles assigned to UAT before prod schema refresh…
Thank you
Kris k