Re: [GENERAL] Script to export all privileges to csv or similar

2008-08-22 Thread Terry Lee Tucker
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
[EMAIL PROTECTED]
www.turbocorp.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Script to export all privileges to csv or similar

2008-08-22 Thread Anton Melser
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 ...

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general