The create schema privilege is missed from the dump file.
Thanks,
Suya
From: Raghu Ram [mailto:raghuchennuru@gmail.com] Sent: Thursday, November 07, 2013 4:06 PM To: Huang, Suya Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] view to get all role privileges
Thanks Ram, but those command doesn’t help here… The goal is to dump all privileges in a database and execute it on the new database to make sure we have exactly the same environment.
Command to get all privileges from respective Database: