Hello all,
How do I capture the EXISTING permissions for a database? I know you can
see them via \z or \dp however I need ALL permissions to be captured so I
can reapply after performing a database restore.
ex:
1) dump database A -
2) Extract permissions from database B - (HOW????)
3) load database B from A -
4) execute sql to put permissions back to database B from step 2
Thanks...Michelle
--
View this message in context:
http://www.nabble.com/Extracting-%5C-Generate-DDL-for-existing-object-permissions-tp17413948p17413948.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
