Thread: How to display default privileges?

Hi everyone,

from what I know, since PostgreSQL 9.0 it is supported to change default
privileges for newly created tables, functions and sequences by using
"ALTER DEFAULT PRIVILEGES".

How to display the current settings?

Best regards,
Marc

On 09/05/2016 03:17 PM, Marc Richter wrote:
> Hi everyone,
>
> from what I know, since PostgreSQL 9.0 it is supported to change default
> privileges for newly created tables, functions and sequences by using
> "ALTER DEFAULT PRIVILEGES".
>
> How to display the current settings?

You can use psql's \ddp, or look in pg_default_acl directly.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support