Re: Dumping grants - Mailing list pgsql-novice

From Tom Lane
Subject Re: Dumping grants
Date
Msg-id 28363.1287367061@sss.pgh.pa.us
Whole thread Raw
In response to Dumping grants  (richard terry <rterry@pacific.net.au>)
List pgsql-novice
richard terry <rterry@pacific.net.au> writes:
> ?Any way to dump the grants on all tables/sequences in a DB to a text file?

There's no canned solution for that, but you could run "pg_dump -s"
and then grep the output for GRANT statements.

            regards, tom lane

pgsql-novice by date:

Previous
From: richard terry
Date:
Subject: Dumping grants
Next
From: Lukasz Brodziak
Date:
Subject: Re: Overriding local encoding defaults