List the database privileges using psql

Question

I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL using the psql command line tool?

I'm on Ubuntu 11.04 and my PostgreSQL version is 8.2.x.

Thanks in advance. Cheers.

Answer 1

postgres=> \l
                                   Liste der Datenbanken
      Name      | Eigentümer | Kodierung | Sortierfolge | Zeichentyp |  Zugriffsprivilegien  
   ----------------+------------+-----------+--------------+------------+-----------------------
postgres       | postgres   | UTF8      | de_AT.utf8   | de_AT.utf8 | 
template0      | postgres   | UTF8      | de_AT.utf8   | de_AT.utf8 | =c/postgres
                                                                      : postgres=CTc/postgres
template1      | postgres   | UTF8      | de_AT.utf8   | de_AT.utf8 | =c/postgres
                                                                      : postgres=CTc/postgres

The docs give an explanation of how to interpret this output. For specific privilages an a table of the current DB, use \z YOURTABLE

Answer 2

perhaps you mean listing users and their privileges for a database - I can't quite tell from the question:

postgres=> \du
                             List of roles
    Role name    |  Attributes  |                    Member of
-----------------+--------------+------------------------------------------------
 dba             | Create role  | {util_user,helpdesk_user,helpdesk_admin}
 helpdesk_admin  | Cannot login | {helpdesk_user}
 helpdesk_user   | Cannot login | {helpdesk_reader}
 jack            |              | {helpdesk_admin}
 postgres        | Superuser    | {}
                 : Create role
                 : Create DB