Re: Script to export all privileges to csv or similar

From: Terry Lee Tucker <terry(at)chosen-ones(dot)org>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Script to export all privileges to csv or similar
Date: 2008-08-22 11:27:56
Message-ID: 200808220727.57006.terry@chosen-ones.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 22 August 2008 05:15, Anton Melser wrote:
> Hi,
> Does anyone know of a script/tool that allows one to export all users
> with all privileges? I realise I could construct a query to do it but
> google turned up nothing and if someone else has done the good work...
> Cheers
> Anton
>
> --
> echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
> This will help you for 99.9% of your problems ...

Have you looked at pg_dumpall -g ?
--
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987
terry(at)turbocorp(dot)com
www.turbocorp.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2008-08-22 11:31:05 Re: [GENERAL] LIKE and SIMILAR TO
Previous Message RW 2008-08-22 11:24:21 Re: LIKE and SIMILAR TO